Forum Discussion

johnvonc's avatar
johnvonc
Copper Contributor
Jun 03, 2024

Databricks with Simba spark ODBC dsn

I am using the Simba Spark ODBC driver to create a dsn to connect to a Databricks instance. When tested, it passes. When I go in to Access to link to the data, Access is only pulling a subset of the available tables and views. If I try to attach Databricks to Excel, using the same dsn, it returns all schemas, views and tables. Any help would be appreciated getting Access to work correcctly.

Resources