# Connecting to Databricks

Install the Databricks ODBC Driver from here: [https://www.databricks.com/spark/odbc-drivers-download](<https://www.databricks.com/spark/odbc-drivers-download>)

## Example connection string

Text Only

```text
Driver=Simba Spark ODBC Driver;Host=<workspace-id>.<region>.azuredatabricks.net;Port=443;HTTPPath=/sql/1.0/warehouses/<warehouse-id>;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: