This Storage Integration terraform module creates the base infrastructure to build storage only pipelines that load data from S3 to Snowflake. The resources created are:
- Snowflake Storage Integration
- S3 Bucket
- S3 Bucket Event
- AWS SNS topic
- AWS IAM Role with perms required to access the bucket, and publish/subscribe to SNS topic
- Trust relationship between the Snowflake Storage integration and AWS IAM Role