terraform-snowflake-oauth-integrations module

This is a repository that makes a schema with a schema_grant with Snowflake:

• schema
• schema_grant

Example CICD with BitBucket and Codefresh:

Usage

To use the module you will need to use the following:

module "snowflake_schema_test" {
  source  = "https://github.com/Richard-Barrett/terraform-snowflake-schemas"
  version = "0.0.1"

  database     = "TEST"
  schema_name  = "TEST"
}

Required Values:

Values
database
schema_name

Overview

In overview, this repository acts as a digestible module that allows you to create schemas with an associated schema_grant in Terraform for Snowflake.

Requirements

Name	Version
terraform	>= 1.5.7
snowflake	~> 0.89.0

Providers

Name	Version
snowflake	~> 0.89.0

Modules

No modules.

Resources

Name	Type
snowflake_schema.this	resource
snowflake_schema_grant.this	resource

Inputs

Name	Description	Type	Default	Required
comment	value for comment	string	""	no
data_retention_days	value for data retention days	number	30	no
database	Name of the database for granting schema access	string	n/a	yes
enable_multiple_grants	When this is set to true, multiple grants of the same type can be created. This will cause Terraform to not revoke grants applied to roles and objects outside Terraform.	bool	true	no
is_managed	value for is_managed	bool	false	no
is_transient	value for is_transient	bool	false	no
on_all	When this is set to true, apply this grant on all schemas in the given database. The schema_name and shares fields must be unset in order to use on_all. Cannot be used together with on_future.	bool	false	no
on_future	(Boolean) When this is set to true, apply this grant on all future schemas in the given database. The schema_name and shares fields must be unset in order to use on_future. Cannot be used together with on_all.	bool	false	no
privilege	Privilege for the schema grant	string	"USAGE"	no
roles	List of roles to grant access to schema_name	list(string)	[ "" ]	no
schema_name	Name of the schema	string	n/a	yes
shares	Grant privilege to shares (only valid if on_future and on_all are unset 'DEFAULT')	list(string)	n/a	yes
with_grant_option	(Boolean) When this is set to true, allows the recipient role to grant the privileges to other roles.	bool	false	no

Outputs

No outputs.