Hi,
I have a Databricks Workflows DBT task that targets a PRO SQL warehouse. However, the task fails with a "to many retries" error (see below) if the PRO SQL warehouse is not up and running when the task starts. How can I increase the timeout or allowed number of retries (for the DBT task connecting to the PRO SQL Warehouse)?
Error message:
12:03:16 Finished running in 0 hours 5 minutes and 4.37 seconds (304.37s).
12:03:16 Encountered an error: Database Error HTTPSConnectionPool(host='adb-5482477729738913.13.azuredatabricks.net', port=443): Max retries exceeded with url: /sql/1.0/warehouses/d426dd371415ad72 (Caused by ResponseError('too many 503 error responses'))