โ02-16-2023 02:45 AM
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.
โ04-09-2023 08:11 AM
@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:
If the above steps do not help, you can try reaching out to Tableau support for further assistance.
โ04-21-2023 01:26 AM
Thanks for your reply, @Suteja Kanuriโ
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
โ04-21-2023 12:03 AM
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!
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโt want to miss the chance to attend and share knowledge.
If there isnโt a group near you, start one and help create a community that brings people together.
Request a New Group