Skip to content

rapid-snowflake-deployment

Latest
Compare
Choose a tag to compare
@AdamDewberry AdamDewberry released this 22 Dec 01:23
· 24 commits to master since this release
68637ff

This release uses Terraform 13 to rapidly deploy Snowflake resources to support automated data ingestion and exports to AWS S3.

Updates:

  • Code to create an AWS CI user & role (which the user can adopt) to support automated deployments using CI/CD.
  • Automated Snowflake deployment pipelines with GitHub actions CI/CD workflows.
  • Snowflake tasks data export module to automate data unloading to S3.

The tooling can create the following resources and their dependencies:

  • AWS S3 state bucket & DynamoDB lock table
  • AWS S3 data lake
  • AWS IAM roles for PUT & GET on S3 files (necessary for imports to Snowflake using Snowpipes and exports to S3 using External Stages)
  • Snowpipes
  • External Stages
  • Storage Integrations