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

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

FIRST CREATED ON 24 Jan 2025  I  AUTHOR Emma Camacho


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 


Info
Looking for Additional Guidance?
If you require more detailed information or further assistance, please visit our comprehensive Online Documentation. Our resources are designed to help you navigate all features and functionalities effectively.