Specifies whether the provider checks the availability of the SQL Warehouse in Databricks before establishing a connection.

Syntax

Connect-Databricks -CheckSQLWarehouseAvailability bool

Data Type

bool

Default Value

true

Remarks

When this property is set to true, the cmdlet 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 cmdlet 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.