database
Infostrux-Solutions/database/snowflake
Open Source Snowflake Terraform Module for Database Object Implementation, also in the terraform registry, https://registry.terraform.io/modules/Infostrux-Solutions/database/snowflake/latest
Snowflake Database Terraform Module Quickly deploy Snowflake Database resources and attach Grants using a Terraform Module. Usage## Usage Simple usage: ``hcl module "database" { source = "Infostrux-Solutions/database/snowflake" name = "DATABASE_NAME" comment = "Created by Terraform" } ` Full usage: `hcl module "database" { source = "Infostrux-Solutions/database/snowflake" name = "DATABASE_NAME" attach_grant_usage = true usage_roles = ["SYSADMIN"] usage_shares = [] usage_with_grant_option = true attach_grant_modify = true modify_roles = ["SYSADMIN"] modify_shares = [] modify_with_grant_option = true attach_grant_create_schema = true create_schema_roles = ["SYSADMIN"] create_schema_shares = [] create_schema_with_grant_option = true attach_grant_monitor = true monitor_roles = ["SYSADMIN"] mon
| Name | Type | Description | Default |
|---|---|---|---|
| name | string | The name to apply to the database resource. | |
| 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 database. | [] |
| create_schema_roles | list(string) | A list of roles that will be granted create_schema on the database. | [] |
| data_retention_time_in_days | string | Days to retain deleted data for. Default is 1 | 1 |
| usage_shares | list(string) | A list of roles that will be granted usage on the database shares. | [] |
| modify_roles | list(string) | A list of roles that will be granted modify on the database. | [] |
| modify_shares | list(string) | A list of roles that will be granted modify on the database shares. | [] |
| attach_grant_modify | bool | Create the grant modify at the same time. (true|false) | false |
| modify_with_grant_option | bool | When this is set to true, allows the recipient role to grant the privileges to o | false |
| create_schema_shares | list(string) | A list of roles that will be granted create_schema on the database shares. | [] |
| comment | string | A comment to add to the database resource. | "Created by Terraform." |
| usage_with_grant_option | bool | When this is set to true, allows the recipient role to grant the privileges to o | false |
| attach_grant_create_schema | bool | Create the grant create_schema at the same time. (true|false) | false |
| create_schema_with_grant_option | bool | When this is set to true, allows the recipient role to grant the privileges to o | false |
| attach_grant_monitor | bool | Create the grant monitor at the same time. (true|false) | false |
| monitor_roles | list(string) | A list of roles that will be granted monitor on the database. | [] |
| monitor_shares | list(string) | A list of roles that will be granted monitor on the database shares. | [] |
| monitor_with_grant_option | bool | When this is set to true, allows the recipient role to grant the privileges to o | false |
database_id — The database resource ID.database_name — The database resource name.