10-22-2023 08:47 PM
We are attempting to connect a Windows ODBC application to Unity Catalog.
The Configure the Databricks ODBC and JDBC drivers documentation has a section titled "ODBC configuration and connection parameters" that mentions a configuration parameter called Catalog that sets the Default Catalog.
However, we cannot figure out where to put this parameter in the Windows ODBC Data Sources interface.
Has anyone managed to configure a Windows DSN to point to a specific Databricks catalog?
10-22-2023 10:26 PM
@John_Rotenstein You just need to build a connection string
Driver=<path-to-driver>;Host=<server-hostname>;Port=443;HTTPPath=<http-path>;ThriftTransport=2;SSL=1;AuthMech=3;UID=token;PWD=<personal-access-token>;Schema=<schema>;Catalog=<catalog>
10-22-2023 11:04 PM
Ah! So are you saying that I would need to configure the application with a Connection String instead of using the ODBC Data Source Administrator DSN UI?
Or can I put that Connection String somewhere in the DNS configuration?
10-23-2023 07:24 AM
Hi John,
Catalog is optional, you don't need to provide in the DSN UI.
11-28-2023 09:15 AM
But how is this possible to set directly in Windows? I need to set both catalog and schema else the default query to get tables is nonsense.
Thanks for any input.
BTW. I hate windows, doing this on Linux is soo much easier.
01-31-2024 08:37 AM
I got this working by adding an entry for catalog in this location in the registry
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBC.INI\Simba Spark
Excited to expand your horizons with us? Click here to Register and begin your journey to success!
Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!