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.

​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.  Read More

​