Dust · My workspace
How many orders did we ship per region last week in main.sales.orders? Compare with the week before.
dust
Completed in 9 sec
Using Databricks SQL
I ran a read-only query on main.sales.orders for the last two full weeks. Here are the shipped orders by region.
Shipped orders, week of Sep 21 vs Sep 14
- EMEA. 4,812 orders, up from 4,390 (+9.6%).
- North America. 6,105 orders, down from 6,420 (-4.9%).
- APAC. 2,237 orders, up from 2,011 (+11.2%).
Worth a look
- North America dip. Most of the drop is on Sep 23 and 24. 318 orders on those days still have status 'pending_carrier'.
What you can do with Databricks SQL
Answers straight from your tables
Ask in plain words. Dust writes the SQL, runs it on your Databricks workspace, and sums up the rows it gets back.
execute_sql_read_only
poll_sql_result
Read-only by default
Lookups go through a read-only tool that runs without a prompt. Any statement that can change data asks for your approval first.
execute_sql_read_only
execute_sql
Long queries still come back
Some queries take a while on a large table. Dust checks on the statement until it finishes, then reads the result.
poll_sql_result
Supported actions in Databricks SQL
Read & Search
- Execute Sql Read Only
- Poll Sql Result
Create & Update
- Execute Sql
3 total actions available (2 read, 1 write)
Frequently asked questions about Databricks SQL
Run SQL on your Databricks workspace and read the results. Agents can run read-only queries, check on long-running statements, and run other SQL statements after you approve them.
Only with your approval. Read-only queries run without a prompt. The general SQL tool, which can write, always asks you to confirm before it runs. What it can touch is also limited by the permissions of the Databricks account used.
An admin enters your Databricks workspace URL and the client ID and secret of a Databricks OAuth app. Dust then connects to the Databricks-managed SQL MCP server with OAuth. The connection can be shared by the workspace or set up per user.
Other integrations you might like
Get started with Databricks SQL
Connect Databricks SQL to Dust and let AI agents handle your workflows.
14-day free trial. No credit card required.