sql_warehouses.md

subcategory
Databricks SQL

databricks_sql_warehouses Data Source

-> Note If you have a fully automated setup with workspaces created by databricks_mws_workspaces or azurerm_databricks_workspace, please make sure to add depends_on attribute in order to prevent default auth: cannot configure default credentials errors.

Retrieves a list of databricks_sql_endpoint ids, that were created by Terraform or manually.

Example Usage

Retrieve all SQL warehouses on this workspace on AWS or GCP:

data "databricks_sql_warehouses" "all" {
  depends_on = [databricks_mws_workspaces.this]
}

Retrieve all clusters with "Shared" in their cluster name on this Azure Databricks workspace:

data "databricks_sql_warehouses" "all_shared" {
  depends_on              = [azurerm_databricks_workspace.this]
  warehouse_name_contains = "shared"
}

Argument Reference

• warehouse_name_contains - (Optional) Only return databricks_sql_endpoint ids that match the given name string.

Attribute Reference

This data source exports the following attributes:

• ids - list of databricks_sql_endpoint ids

Related Resources

The following resources are often used in the same context:

• End to end workspace management guide.
• databricks_instance_profile to manage AWS EC2 instance profiles that users can launch databricks_cluster and access data, like databricks_mount.
• databricks_sql_dashboard to manage Databricks SQL Dashboards.
• databricks_sql_global_config to configure the security policy, databricks_instance_profile, and data access properties for all databricks_sql_endpoint of workspace.
• databricks_sql_permissions to manage data object access control lists in Databricks workspaces for things like tables, views, databases, and more.