With the Azure Databricks (Custom) Connector, I want to be able to connect to the Unity Catalog, currently through the Advance Options I can choose catalog but then I have to specifically go after each folder. Is there a way to display the entire Catalog

[Wayne Thomas]

With the Azure Databricks (Custom) Connector, I want to be able to connect to the Unity Catalog, currently through the Advance Options I can choose catalog but then I have to specifically go after each folder. Is there a way to display the entire Catalog

[Dave Leigh]

Hi Wayne

I want to make sure I understand your request. Are you asking if we could just skip specifying the catalog and just show the results for each catalog (and under them the databases) on the data selection page?

If that is what you are asking, then unfortunately there does not seem to be a way to enumerate the available catalogs to achieve this. We are meeting with Microsoft later this week and this is one of the items I will be bringing up with them.

Cheers

Dave

[Wayne Thomas]

Thank Dave - this is exactly what I was specifying. Through PowerBI we can connect and see the entire unity catalog, but through this connector we have to specify the catalog and database. We currently have well over a dozen and as such would have to create a dozen connections into the Unity Catalog.

[Dave Leigh]

Good, thanks for confirming. It looks like we now have a way to do this, so it has been added to the backlog for the Connector.

If everything goes to plan, we should be able to start on this around the middle of June.

Cheers

Dave