Snowpipe is a newly available tool that can be used as an alternative for moving S3 data into snowflake. Snowpipe is likely going to cost less and give us more control over the import process of the files then fivetran does.

This spike is to review the snowpipe documentation and document how we can use it to move swatch data into snowflake

https://dataverse.pages.redhat.com/data-docs/platform-teams/snowflake/snowpipe/snowpipe/

Contacts on that may be able to help with SnowPipe:

• Mark Hawkins
• Michael Sanborn
• Martin Bacovsky

Acceptance Criteria:
The following is documented in inscope:

• Is snowpipe a viable option for us?
• What is required for us to get it to work
• Pros and cons of using snowpipe