[Feature Request] Add support for SQL Warehouse in DAB

[hariaculeti]

Describe the issue

Unable to create new sql warehouse in DAB

Configuration

not needed

Steps to reproduce the behavior

Could you please let me know the roadmap on when sql warehouse is added in DAB?

Expected Behavior

Expect DAB to support all terraform modules. We are in the process of moving away from Terraform to DAB and expect all the TF module blocks to be available in DAB

Actual Behavior

not needed

OS and CLI version

Databricks CLI v0.236.0

Is this a regression?

not needed

Debug Logs

not needed

[hariaculeti]

Please add warehouse and permissions to DAB

[hariaculeti]

@andrewnester .. could you please let me know the approximate ETA for this feature to be available so that we can plan accordingly.. Thanks

[andrewnester]

@hariaculeti this is not yet on our roadmap unfortunately so no ETA, we might consider it for Q2, so I will keep this issue updated with any progress

[haveyoumetcp]

Would like to see this as well.

[miguelCalado]

Same here, it would be really nice to be able to create SQL warehouses in bundles.

[github-actions[bot]]

This issue has not received a response in a while. If you want to keep this issue open, please leave a comment below and auto-close will be canceled.

[haveyoumetcp]

Still want this

[hariaculeti]

@andrewnester .. any update on this request please?

[goda]

would be nice to have this added!

[ksummerlin]

In addition to creating a warehouse, it would be beneficial to be able to look up the warehouse ID later on (like we can with cluster lookup).

[pietern]

@ksummerlin It is possible to look up a warehouse ID if one exists today, see the docs or this example.

[andrewnester]

SQL warehouse support was just added in 0.260.0 CLI release, please give it a try https://github.com/databricks/cli/releases/tag/v0.260.0

[hariaculeti]

@andrewnester Thanks for looking into this. I am able to deploy the warehouse but I am unable to provide permissions. Can you check if permissions are added to warehouses? If yes, please provide an example

[hariaculeti]

@andrewnester .. do you want to reopen the issue or should I raise new issue for permissions? Please confirm.

[andrewnester]

@hariaculeti yes, permissions should be set using this configuration as an example

resources:
  sql_warehouses:
    test_sql_warehouse:
      name: sql_warehouse_name
      cluster_size: X-Large
      enable_serverless_compute: true
      max_num_clusters: 1
      min_num_clusters: 1
      auto_stop_mins: 120
      permissions:
        - group_name: "users"
          level: "CAN_USE"
        - group_name: "viewers"
          level: "CAN_VIEW"

You can see details here https://github.com/databricks/cli/pull/3280

Do you receive specific type of error?

[hariaculeti]

@andrewnester I was having typo in permissions (was using privileges instead of level) and that was causing issue. Its working beautifully now. Thanks a lot for your help.