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

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.