Database provider configuration

Databricks Configuration

ODBC driver configuration

odbci.ini File (DSN Entries)
On /app/odbc-config/odbc.ini

[databrick]
Driver=/app/odbc-lib/simba/spark/lib/libsparkodbc_sb64.so
SparkServerType=3
Host=adb-1310115530005442.2.azuredatabricks.net
Port=443
SSL=1
Min_TLS=1.2 
Token
ThriftTransport=2
AuthMech=3
TrustedCerts=/app/odbc-lib/spark/lib/64/cacerts.pem
UseSystemTrustStore=0
HTTPPath=/sql/1.0/warehouses/c546e1e69e8d2ac9
UID=token
PWD=<generated token> 

User credentials

Personal access token

1. Log in using corp account.

2. You can create your own personal access token from User Settings>User>Developer>Access Token.
   

   

3. Use “token” as username and then for password enter you personal access token.

Interaction configuration

Schema

Schema = <catalog>.<schema>

Additional resources

• Best practices: Databricks