cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Get Started Discussions
Start your journey with Databricks by joining discussions on getting started guides, tutorials, and introductory topics. Connect with beginners and experts alike to kickstart your Databricks experience.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Databricks SQL warehouse best practices

Phani1
Valued Contributor II

How best we can design Databricks SQL warehouse for multiple environments, and multiple data marts, is there any best practices or guidelines?

1 ACCEPTED SOLUTION

Accepted Solutions

Anonymous
Not applicable

Hi @Phani1 

We haven't heard from you since the last response from @Vinay_M_R , and I was checking back to see if her suggestions helped you.

Or else, If you have any solution, please share it with the community, as it can be helpful to others. 

Also, Please don't forget to click on the "Select As Best" button whenever the information provided helps resolve your question.

View solution in original post

2 REPLIES 2

Vinay_M_R
Valued Contributor II
  • 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

Anonymous
Not applicable

Hi @Phani1 

We haven't heard from you since the last response from @Vinay_M_R , and I was checking back to see if her suggestions helped you.

Or else, If you have any solution, please share it with the community, as it can be helpful to others. 

Also, Please don't forget to click on the "Select As Best" button whenever the information provided helps resolve your question.

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group