Databricks SQL with the warehouse under control
Unity Catalog in the tree, a warehouse bar that asks before starting a billed warehouse, Explain Formatted with Photon operators, and Delta history with restore.
- Databricks SQL on AWS, Azure and GCP (tested against a mock workspace)
What you get for Databricks SQL
Warehouse bar
Pick the warehouse, see its state, start it (asks first, since a running warehouse is billed) and stop it. A statement that would start a stopped warehouse asks too.
Unity Catalog
Catalogs, schemas, tables, views, materialized views, streaming tables, volumes and functions, with SHOW CREATE TABLE DDL.
Delta history
DESCRIBE HISTORY for Delta tables, with Restore to version after you type the table name.
Plans and history
Explain Formatted with Photon operators and scans without a pushed filter flagged; Explain Analyze adds time, rows, files read, pruning and spill.
- Databricks support is tested against a mock workspace, not a real Databricks account yet.
And everything every connection gets
Each database keeps its own tools, and shares one workspace with the others.
- Projects with Development, Staging and Production environments, enforced on every write
- Logs & analytics: the server's log, slow operations by shape and live metrics
- An AI assistant that writes and fixes this family's queries, with your own key
- Read-only connections, typed confirmations and a local audit log
- Saved queries as files in a folder you can put in Git
- Notebooks and charts on live results
Features to look at next
Also in analytics and warehouses: ClickHouse, Snowflake, Google BigQuery.
Your next query deserves a better IDE.
Create a free account, download MotionQL, and paste your Pro key. You'll be querying in under two minutes.