Databricks

Databricks

  • Purpose: Connect to Databricks, a unified analytics platform built on Apache Spark.
  • When to use it: Ideal for querying Delta Lake tables and ML-ready data in Databricks SQL warehouses.
  • How to create it:
    1. Go to Data Sources and click Add.
    2. Select Databricks.
    3. Name: Enter a unique name for this connection.
    4. Server Hostname: Your Databricks workspace hostname (e.g., adb-1234567890.1.azuredatabricks.net).
    5. HTTP Path: SQL warehouse or cluster HTTP path (e.g., /sql/1.0/warehouses/xxxx). Found under SQL Warehouses → Connection Details.
    6. Access Token: A Databricks personal access token. Generate at User Settings → Developer → Access Tokens.
    7. Catalog: (Optional) Unity Catalog name (leave blank to use the default hive_metastore).
    8. Schema: (Optional) Default schema to use within the catalog.
    9. Click Test Connection to verify, then Save.

Databricks Configuration