cancel
Showing results for 
Search instead for 
Did you mean: 
Community Discussions
Connect with fellow community members to discuss general topics related to the Databricks platform, industry trends, and best practices. Share experiences, ask questions, and foster collaboration within the community.
cancel
Showing results for 
Search instead for 
Did you mean: 

Updating Databricks SQL Warehouse using Terraform

Sudheer2
New Contributor II
 

We can Update SQL Warehouse manually in Databricks.

Click SQL Warehouses in the sidebar

In Advanced options

We can find Unity Catalog toggle button there!

 

While Updating Existing SQL Warehouse in Azure to enable unity catalog using terraform, I couldn't find proper documentation.

Can anyone please explain.

#SqlWarehouse #EnableUnityCatalog #Compute #terraform

2 REPLIES 2

Kaniz
Community Manager
Community Manager

Hi @Sudheer2,

  • The Unity Catalog is a feature in Databricks SQL Warehouse that allows you to query data across multiple databases and tables seamlessly. It provides a unified view of your data.
  • When you enable the Unity Catalog, you can access tables from different databases within the same workspace without explicitly specifying the database name.
  • To update the configuration of a SQL warehouse in Databricks, you can use the Databricks REST API.
  • Specifically, you can use the POST /api/2.0/sql/warehouses/{id}/edit endpoint to modify the configur...1.
  • The {id} parameter represents the ID of the warehouse you want to configure.
  • While Terraform is a powerful infrastructure-as-code tool, it’s essential to note that it primarily focuses on managing cloud resources (such as VMs, networks, storage, etc.).
  • For managing the configuration of services within Databricks (including SQL Warehouses), you might need to combine Terraform with other tools or manual steps.
  • The recommended pattern for updating an Azure SQL Data Warehouse table from Databricks is as follows:

 Good luck with your SQL Warehouse configuration! 😊🚀342.

  1.  

KaseyHampton
New Contributor II

Thanks for answering, you made my day. If I want to know more, I will ask by starting my own thread.

I was actually searching for this https://notgamstop.com/uk-gb/gamstop-faq/how-to-get-around-gamstop/ website because I want to know how to get round Gamstop and while searching for it online, I found your post.
Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!