OptionalautoOptionalchannelChannel Details
OptionalclusterSize of the clusters allocated for this warehouse. Increasing the size of a spark cluster allows you to run larger queries on it. If you want to increase the number of concurrent queries, please tune max_num_clusters.
Supported values:
Optionalcreatorwarehouse creator name
OptionalenableConfigures whether the warehouse should use Photon optimized clusters.
Defaults to true.
OptionalenableConfigures whether the warehouse should use serverless compute
OptionalhealthOptional health status. Assume the warehouse is healthy if this field is not set.
Optionalidunique identifier for warehouse
OptionalinstanceDeprecated. Instance profile used to pass IAM role to the cluster
Optionaljdbcthe jdbc connection string for this warehouse
OptionalmaxMaximum number of clusters that the autoscaler will create to handle concurrent queries.
Supported values:
Defaults to min_clusters if unset.
OptionalminMinimum number of available clusters that will be maintained for this SQL warehouse. Increasing this will ensure that a larger number of clusters are always running and therefore may reduce the cold start time for new queries. This is similar to reserved vs. revocable cores in a resource manager.
Supported values:
Defaults to 1
OptionalnameLogical name for the cluster.
Supported values:
OptionalnumDeprecated. current number of active sessions for the warehouse
Optionalnumcurrent number of clusters running for the service
OptionalodbcODBC parameters for the SQL warehouse
OptionalspotConfigurations whether the endpoint should use spot instances.
Optionalstatestate of the endpoint
OptionaltagsA set of key-value pairs that will be tagged on all resources (e.g., AWS instances and EBS volumes) associated with this SQL warehouse.
Supported values:
OptionalwarehouseWarehouse type: PRO or CLASSIC. If you want to use serverless compute,
you must set to PRO and also set the field enable_serverless_compute to true.
The amount of time in minutes that a SQL warehouse must be idle (i.e., no RUNNING queries) before it is automatically stopped.
Supported values:
Defaults to 120 mins