CheckSQLWarehouseAvailability
Specifies whether the provider checks the availability of the SQL Warehouse in Databricks before establishing a connection.
Data Type
bool
Default Value
true
Remarks
When this property is set to true, the driver performs a preliminary check to verify that the target SQL Warehouse in Databricks is active before completing the connection. This helps prevent query failures caused by inactive or paused warehouses.
When this property is set to false, the driver skips the availability check and attempts to connect immediately. This can shorten connection time but may result in an error if the warehouse is not running.
This property is useful for ensuring connection stability in environments where SQL Warehouses may pause due to idle time or cost-saving configurations.