How to configure an ODBC Datasource to DataBricks with Simba Spark ODBC Driver

CONNECTION STRING

For this Connection String, you can start with this example, but you can add more settings.

Driver=Simba Spark ODBC Driver; Host=xxxx.azuredatabricks.net; Port=443; HTTPPath=/sql/1.0/warehouses/xxxx; SSL=1; ThriftTransport=2; AuthMech=3; Database=xxxx; UID=token; PWD=*****;

FIELD QUERY SQL

For this field, try the following query and add the where clause you need:

SELECT Distinct  table_name as TABLE_NAME, column_name as COLUMN_NAME FROM information_schema.columns

TABLE QUERY SQL

For this field, try the following query and add the where clause you need:

SELECT Distinct  table_name as TABLE_NAME FROM information_schema.tables where TABLE_TYPE = 'MANAGED'

VIEW QUERY SQL

For this field, try the following query and add the where clause you need:

SELECT Distinct  table_name as TABLE_NAME FROM information_schema.tables where TABLE_TYPE = 'VIEW'

For more in information, see 

https://help.mail-and-deploy.com/docs/odbc-datasources

https://docs.databricks.com/en/sql/language-manual/information-schema/tables.html