snowpipe

Infostrux-Solutions/snowpipe/snowflake

Terraform Module HCL SNOWFLAKE

Open Source Snowflake Terraform Module for Snowpipe Implementation, also in the terraform registry, http://registry.terraform.io/modules/Infostrux-Solutions/snowpipe/snowflake/latest

Install

module "snowpipe" {

source = "Infostrux-Solutions/snowpipe/snowflake"

version = "0.4.0"

}

plain text: /constructs/tfmod-infostrux-solutions-snowpipe-snowflake/install.txt

⭐ Source on GitHub 📦 Registry page

README

Snowflake Snowpipe Terraform Module Terraform module that create all the Snowflake resources to received data from snowpipe. Usage To run this example you need to execute: ``bash $ terraform init $ terraform plan $ terraform apply ` Run terraform destroy when you don't need the user. Requirements | Name | Version | |------|---------| | terraform | >= 0.13.1 | | aws | >=4.25.0 | | snowflake | >=0.40.0 | Providers | Name | Version | |------|---------| | aws | 4.25.0 | | snowflake | 0.40.0 | Modules No modules. Resources | Name | Type | |------|------| | aws_s3_bucket_notification.notification | resource | | snowflake_pipe.pipe | resource | | snowflake_stage.stage | resource | Inputs | Name | Description | Type | Default | Required | |------|-------------|------|---------|:--------:| | bucket

Inputs (10)

Name	Type	Description	Default
stage_url	string	S3 full url ex: s3_id/path	required
pipe_name	string	Object for the pipe's stage configuration	required
stage_name	string	Stage name in capital letter	required
schema	string	Schema for the pipe and the stage	required
table	string	Table for the pipe and the stage	required
file_format	string	Table for the pipe and the stage	required
bucket_id	string	Pipe's bucket where to fetch the data	required
storage_integration_name	string	Name of the storage integration that the external stage will use	required
database	string	Database for the pipe and the stage	required
pipe_copy_statement	string	Pipe sql query to copy the data from S3 to the ingest table	`""`