Connecting to Databricks

Install the Databricks ODBC Driver from here: https://www.databricks.com/spark/odbc-drivers-download

Example connection string¶

Driver=Simba Spark ODBC Driver;Host=adb-5273594171.11.azuredatabricks.net;Port=443;HTTPPath=/sql/1.0/warehouses/a2fa3ec5b46;ThriftTransport=2;SSL=1;AuthMech=3;UID=token;PWD=

Use a Custom Query to view the list of databases:

You can write a Custom Query to get the list of tables in a database:

Finally you can write a Custom Query to retrieve the data from a table: