warehouse
Infostrux-Solutions/warehouse/snowflake
Open Source Snowflake Terraform Module for Warehouse Object Implementation, also in the terraform registry, https://registry.terraform.io/modules/Infostrux-Solutions/warehouse/snowflake/0.1.0
Snowflake Warehouse Terraform Module Quickly deploy Snowflake Warehouse resources and attach Grants using a Terraform Module. Usage Simple usage: ``hcl module "warehouse" { source = "Infostrux-Solutions/warehouse/snowflake" name = "warehouse_name" } ` Full usage: `hcl module "warehouse" { source = "Infostrux-Solutions/warehouse/snowflake" name = "warehouse_name" comment = "This is for describing the warehouse purpose." size = "xsmall" initially_suspended = true auto_resume = true auto_suspend = 300 min_cluster_count = 1 max_cluster_count = 2 max_concurrency_level = 0 scaling_policy = "STANDARD" resource_monitor = "" statement_timeout_in_seconds = 172800 statement_queued_timeout_in_seconds = 0 attach_grant_usage = true usage_roles = ["SYSADMIN"] usage_with_grant_option = true attach_grant_m
| Name | Type | Description | Default |
|---|---|---|---|
| name | string | The name to apply to the Snowflake warehouse. | |
| attach_grant_monitor | bool | Create the grant monitor at the same time. (true|false) | false |
| initially_suspended | bool | Whether or not the warehouse is suspended upon creation (true|false) | true |
| attach_grant_usage | bool | Create the grant usage at the same time. (true|false) | false |
| usage_roles | list(string) | A list of roles that will be granted usage on the warehouse. | [] |
| ownership_roles | list(string) | A list of roles that will be granted ownership on the warehouse. | [] |
| size | string | The size of warehouse to provision for query processing. | "xsmall" |
| modify_with_grant_option | bool | When this is set to true, allows the recipient role to grant the privileges to o | false |
| monitor_roles | list(string) | A list of roles that will be granted monitor on the warehouse. | [] |
| min_cluster_count | number | Smallest cluster size to provision. | null |
| max_cluster_count | number | Largest cluster size to provision. | null |
| scaling_policy | string | Specifies the policy for automatically starting and shutting down clusters in a | null |
| resource_monitor | string | Specifies the name of a resource monitor that is explicitly assigned to the ware | null |
| wait_for_provisioning | bool | Specifies whether the warehouse, after being resized, waits for all the servers | null |
| statement_queued_timeout_in_seconds | number | Object parameter that specifies the time, in seconds, a SQL statement (query, DD | 0 |
| modify_roles | list(string) | A list of roles that will be granted modify on the warehouse. | [] |
| operate_roles | list(string) | A list of roles that will be granted operate on the warehouse. | [] |
| operate_with_grant_option | bool | When this is set to true, allows the recipient role to grant the privileges to o | false |
| monitor_with_grant_option | bool | When this is set to true, allows the recipient role to grant the privileges to o | false |
| statement_timeout_in_seconds | number | Specifies the time, in seconds, after which a running SQL statement (query, DDL, | 172800 |
| comment | string | Comment (description) to add to the warehouse. | "Created by Terraform" |
warehouse_name — The Warehouse resource name.warehouse_id — The Warehouse resource ID.