Query information schema under Catalogs from Tableau Desktop - what are the permissions?

mimoliho
New Contributor II

Hi there,

We have Unity Catalogs enabled in Azure Databricks.

I would like to connect to system.information_schema.* or any other *.information_schema.*.

Querying in UI or other IDEs works as expected -

select * from system.information_schema.tables.

Now when I'm trying to establish the connection from Tableau Desktop - I can't see system catalog, also under other catalogs I don't see information schemas.

Could you please advise what are the type of permission I should have (as a user or group member) to be able to see system catalog and information schema inside it or other catalogs in Tableau Desktop?

Here is how it looks in Tableau Desktop under Catalog drop down - no System Catalog.

no_system_catalogHere are permissions in system catalog.

system_catalogsyste_catalog_infsystem_catalog_tableAlso attaching current permissions for one of the catalogs. Information Schema also not visible in Tableau Desktop.

dbricks_catalog_permtableau_destop_catalogAny advise will be appreciated.