Import Databricks SQL query results into Google Sheets, schedule auto-refresh, and write data back — works with Unity Catalog, Hive metastore, and Delta Lake tables.
Databricks is where data teams run their most complex analytics — Delta Lake tables, Unity Catalog, ML model outputs. But business stakeholders live in Google Sheets. Brooked bridges the gap: connect your Databricks SQL warehouse to Google Sheets, run queries from the sidebar, and import results on demand or on a schedule. No ETL pipeline, no engineering ticket.
What you can query from Databricks
- Delta Lake tables (Unity Catalog and Hive metastore)
- Materialized views and standard views
- SQL warehouse query results
- ML feature store tables
- Any SQL-accessible object in your Databricks workspace
Step 1 — Install Brooked
Install Brooked from the Google Workspace Marketplace. Free tier includes 100 imports per month — no credit card required.
Step 2 — Connect Databricks
Open the Brooked sidebar and click Add data source → Databricks. You'll need:
- Workspace URL — e.g. https://adb-1234567890.12.azuredatabricks.net
- Personal access token (PAT) — generate one under User Settings → Access Tokens
- SQL warehouse HTTP path — found under SQL Warehouses → your warehouse → Connection Details
- Catalog and schema (if using Unity Catalog)
Step 3 — Run a query and import results
Click New import, select your Databricks connection, and write your SQL query. Choose a destination sheet range and click Import. Enable Auto-refresh to keep results current on a schedule.
Two-way sync — writing data back to Databricks
Brooked supports writing data from Google Sheets back to Databricks Delta tables using MERGE (UPSERT), INSERT, or DELETE. This is useful for data quality workflows where business users flag records in Sheets and need those flags written back to the lakehouse.
Using the AI agent with Databricks
Open the Chat tab and ask questions about your Databricks data in plain English. The agent inspects your Unity Catalog schema, writes the SQL, and returns results into Sheets.
Brooked AI — DatabricksCommon use cases
- ML model monitoring — pull model performance metrics from Databricks into a stakeholder Sheet
- Business metrics reporting — surface aggregated KPIs from Delta tables in exec-facing dashboards
- Data science sharing — export analysis results from the lakehouse into Sheets for non-technical review
- Data quality — let business users flag records in Sheets and write corrections back to Delta
- Finance reporting — schedule daily imports of revenue and cost data from your lakehouse
Troubleshooting common issues
Frequently asked questions
Can I connect Databricks to Google Sheets without an ETL pipeline?
Yes. Brooked is a Google Sheets add-on that connects to your Databricks SQL warehouse directly. Write SQL in the sidebar, import results into any sheet range, and schedule auto-refresh — no data pipeline required.
Does Brooked support Unity Catalog?
Yes. Brooked supports Unity Catalog and Hive metastore. For Unity Catalog, use three-part table names (catalog.schema.table) in your queries. Set the default catalog in the connection settings.
Can I write data from Google Sheets back to Databricks Delta tables?
Yes — Brooked supports two-way sync with Databricks using MERGE (UPSERT), INSERT, and DELETE on Delta tables. This is a feature unique to Brooked; most Databricks connectors are read-only.
Does Brooked work with Databricks on AWS, Azure, and GCP?
Yes. Brooked works with all Databricks cloud platforms. The workspace URL and HTTP path differ by cloud, but the connection process in Brooked is identical.
Is there a free Databricks connector for Google Sheets?
Yes. Brooked's free tier includes 100 imports per month with no credit card required. The Pro plan is $29/user/month and adds unlimited imports, hourly auto-refresh, and AI chat.
Connect Databricks to Google Sheets today.
Free tier — 100 imports per month, no credit card required. Or see the full Databricks integration details.
Install Brooked free →