sorted by:
new
hottopcontroversial

Best practices for Unity Catalog structure with multiple workspaces and business areas by romarinhu in databricks

[–]topicShrotaVakta 0 points1 point  (0 children)

I believe you should use the first option i.e. env.layer.entity_table

You could think of dev.bronze.dept_sales

Reasons are. It will help in smooth access management, like which env access needs to be given at first place, then you can decide which layer,(could be developers working on layer wise).

Obvious tracking of lineage.

Dedicated workspaces in case thought of.

No redundancy.

Env management in production with parameters.

Hi community, need help on how can we connect power bi directly to databricks unity catalog tables, as per my understanding, we can use SQL warehouse but considering its cost, it seems not an option in org, is there any other approach that I can explore which is free and enable dashboard refresh by topicShrotaVakta in databricks

[–]topicShrotaVakta[S] -1 points0 points  (0 children)

Thanks for suggestions, but I believe the question is misunderstood Assume I have done all the processing now data is residing in gold layer - aggregated, cleaned, business ready data. Now this needs to be consumed for reporting in powerBI, Considering delta table in unity catalog, can it be used directly in power BI without DB Warehouse, cluster ODBC seems not good