โ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