Differentiating factor on Powerbi to Databricks Unity Catalog and other flavours of databricks

GokulanRajan — Tue, 13 Jun 2023 12:47:36 GMT

We are connecting to Databricks unity catalog which allows multiple catalog_names also we connect to aws/azure/gcp data bricks which are non-unity catalog flavors.

In the dataset expressions of these powerbi reports we don't find any differentiating factor between a non-unity vs unity catalog databricks.

Is there a way to find it from any other field of the dataset?

Example -

DataBricks Unity - "let\n Source = Databricks.Catalogs(\"adb-8443049157651279.19.azuredatabricks.net\", \"sql/protocolv1/o/900788168547414/0608-100227-ze5m0gq7\", [Catalog=null, Database=null, EnableAutomaticProxyDiscovery=null]),\n hive_metastore_Database = Source{[Name=\"hive_metastore\",Kind=\"Database\"]}[Data],\n test_profiling_main_Schema = hive_metastore_Database{[Name=\"test_profiling_main\",Kind=\"Schema\"]}[Data],\n stpsale_Table = test_profiling_main_Schema{[Name=\"stpsale\",Kind=\"Table\"]}[Data]\nin\n stpsale_Table"

AzureDataBricks - "let\n Source = Databricks.Contents(\"adb-8651250466505288.8.azuredatabricks.net\", \"sql/protocolv1/o/8651250466505288/0622-214404-awash362\", [Database=null, BatchSize=null]),\n SPARK_Database = Source{[Name=\"SPARK\",Kind=\"Database\"]}[Data],\n default_Schema = SPARK_Database{[Name=\"default\",Kind=\"Schema\"]}[Data],\n diamonds_Table = default_Schema{[Name=\"diamonds\",Kind=\"Table\"]}[Data]\nin\n diamonds_Table";

AWS DataBricks - “let\n Source = Databricks.Catalogs(\"dbc-25e69bfd-44ed.cloud.databricks.com\", \"sql/protocolv1/o/7841352139603430/0118-050057-4xra3flu\", [Database=null, BatchSize=null]),\n hive_metastore_Database = Source{[Name=\"hive_metastore\",Kind=\"Database\"]}[Data],\n technology_Schema = hive_metastore_Database{[Name=\"default\",Kind=\"Schema\"]}[Data],\n strm_dems_Table = technology_Schema{[Name=\"student2\",Kind=\"Table\"]}[Data]\n in\n strm_dems_Table\n”;

topic Differentiating factor on Powerbi to Databricks Unity Catalog and other flavours of databricks in Developer

Differentiating factor on Powerbi to Databricks Unity Catalog and other flavours of databricks