Welcome to the Alteryx Knowledge Base

No Tables are available in Choose Table or Specify Query window using Databricks as the Input Source
user

Created/Edited - 3/21/2026 by Clara Boo | Alteryx

Issue

No tables are displayed in the Choose Table or Specify Query window when connected to Databricks. The window is accessible from the Table or Query option in the Input Data tool and the Query Builder button in the Connect In-DB tool, for example.

 

 

Environment
  • Alteryx Designer
    • Version: All
  • Simba Spark ODBC Driver
    • Version: 2.7.7

 

Prerequisites
  • Databricks

 

Cause

The hive_metastore is used as the default catalog unless specified in any of the following:

  • the connection string or newer ODBC driver
  • cluster/SQL warehouse/workspace
  • SQL session

If there is no schema in the hive_metastore, nothing will be displayed in the Choose Table or Specify Query window.

Resolution

The easiest solution is to add the catalog option with the catalog name that you use in the connection string in the tool to see the tables.

 

Example:

catalog=SalesCatalog;

"SalesCatalog" in the above example is the catalog that is used for the connection.

 

If you use the DSN connection, append the catalog option at the end of the connection string in the tool:

 odbc:DSN=MyDatabricks;UID=token;PWD=__EncPwd1__;Catalog=<CATALOG>;

 

If you are using a DSN-less connection, similarly, append the catalog option at the end of the connection string in the tool.

odbc:Driver={Simba Spark ODBC Driver};host=<HOST>;port=<PORT>;schema=<SCHEMA>;ThriftTransport=2;ssl=1;httpPath=<HTTP_PATH>;AuthMech=3;UID=token;PWD=__EncPwd1__;Catalog=<CATALOG>;

 

 

NOTE: The suggestion is not applicable to Data Connection Manager (DCM). DCM does not currently allow any additional options for DSN-less. In this case, please consider setting a default catalog in Databricks, if applicable. Please work with your Databricks Administrator for this.

 

 

Was this article helpful?