Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-21-2023 03:24 AM
- 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