Vinay_M_R
Databricks Employee
Databricks Employee
  • you can create at least 1 warehouse per business unit for cost controlling 
  • you may want to have multiple WHs within the same BU in order to support different SLAs (i.e. 1 WH for interactive analyst/developers and 1 to support a production Dashboard)
  • you don't need to separate WHs for data governance purposes, since data access is managed by Unity Catalog
  • use WH tags to facilitate observability
  • use API/Terraform to automate WH provisioning
  • use API (i.e. for query, alerts) to monitor query executions and for QA purposes.
  • use serverless warehouses for lower admin overhead and faster scaling of interactive/bi workloads