topic Re: Query information schema under Catalogs from Tableau Desktop - what are the permissions? in Data Governance

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

mimoliho — Thu, 16 Feb 2023 10:45:40 GMT

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.

Here are permissions in system catalog.

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

Any advise will be appreciated.

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

Anonymous — Sun, 09 Apr 2023 15:11:12 GMT

@Egor Larin :

It looks like you are facing issues with accessing system catalogs and information schemas in Tableau Desktop when connecting to Azure Databricks. Here are a few things you can check:

Check the permissions: Make sure that the user or group you are using to connect to Azure Databricks has the necessary permissions to access system catalogs and information schemas. In Databricks, you can grant permissions to users or groups at the database level using Access Control Lists (ACLs). Make sure that the user or group has been granted the necessary permissions to access the system catalogs and information schemas.
Check the driver settings: Check if you are using the correct JDBC driver to connect to Azure Databricks from Tableau Desktop. You can download the JDBC driver from the Databricks website. Also, make sure that you have specified the correct JDBC URL and driver class in the Tableau Desktop connection settings.
Check the Tableau Desktop version: Make sure that you are using the latest version of Tableau Desktop. Older versions of Tableau Desktop may not be able to access system catalogs and information schemas in Azure Databricks.

If the above steps do not help, you can try reaching out to Tableau support for further assistance.

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

Anonymous — Fri, 21 Apr 2023 07:03:10 GMT

Hi @Egor Larin

Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help.

We'd love to hear from you.

Thanks!

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

mimoliho — Fri, 21 Apr 2023 08:26:27 GMT

Thanks for your reply, @Suteja Kanuri

I have all necessary permissions. I'm the owner (a member in owning group) of another catalog (CAT1) with ALL PRIVILEGES permissions. I'm not able to see the information_schema for CAT1. In UI both information_shemas for system and CAT1 catalog are available, in Tableau Desktop can't see them in drop down when establishing connection, but I can run custom sql query to them from any other selected in drop downs catalogs or shemas (data bases in Tableau).
Using latest ODBC (simba spark 2.06.29.1049) and internal Tableau connector available in Tableau Desktop
Got quite fresh version 2022.3.2 (20223.22.1203.1123) 64-bit

Just wondering if that is Tableau Connector issue... I could try with native ODBC connector, but it looks a bit complicated... so many details I have to provide comparing to Tableau connector. Will let you know