Hi community,
we have several databricks workspaces per different teams and in each workspace several use case covered.
How can we trace the costs per individual use cost for SQL Warehosue / serverless in case we use one SQL warehouse per workspace to cover our needs and don't create one per every use case.
we know about tagging concept and system billing usage table but how could we achieve a cost analysis e.g. per accessed unity catalog catalog or schemas even.
is there any chance to do this?
2nd question goes into the direction of if there is a chance to share a SQL Warehouse / serverless across workspaces for outgoing communications / analytics e.g. from frontends like powerbi or tableau.
thanks
Andreas