I have created the dashboard using the data_connection and workbooks tables from Postgresql repository but not able to find the warehouses name (i.e. started with http_path)
I can see the workbook name Databricks name with there Dbname as unity catalog name
Kindly help me here.
@DIEGO FERNANDO MARTINEZ RODRIGUEZ, @Hasan Mustafa
@Rafik Saudagar your screenshot states that dbname is showing the Unity Catalog/catalog name, not the SQL Warehouse name.
Tableau connects to Databricks using the server hostname and the HTTP Path. The friendly SQL Warehouse name is a Databricks-side label, and it usually is not stored in the Tableau repository as a clean "warehouse name" field. Tableau’s repository data_connections table stores connection fields like server and database name, but the repository is not a complete semantic inventory of every connector-specific property. Tableau also cautions that repository structure can change without warning (tableau.github.io).
For Tableau-only reporting, check whether the HTTP path is available in data_connections.keychain or other connector attribute fields in your Tableau version. If it is not there, Tableau repository alone will not give you the warehouse name.
Better approach would be to combine two sources:
SELECT w.name AS workbook_name, dc.server AS databricks_server, dc.name AS connection_name, dc.dbname AS catalog_or_dbname, dc.keychainFROM public.data_connections dcLEFT JOIN public.workbooks w ON dc.owner_type = 'Workbook' AND dc.owner_id = w.idWHERE dc.server ILIKE '%databricks%' OR dc.dbclass ILIKE '%databricks%' OR dc.dbclass ILIKE '%spark%';
Then extract the HTTP path if it appears in keychain or another connector field, and map that HTTP path to the Databricks SQL Warehouse using the Databricks Warehouses API. Databricks documents SQL warehouses as the compute layer used by Tableau/BI tools, and the API can list warehouses available to the user(Databricks Documentation)
Databricks Warehouses API reference:
https://docs.databricks.com/api/workspace/warehouses/list
In short it would be: Tableau Workbook/Data Source -> Databricks Server + HTTP Path -> Databricks Warehouse API -> Warehouse Name.
If you only have server and dbname, you can identify the Databricks workspace and catalog, but might not get the warehouse name.
