Move data from AWS S3 to Snowflake Data Warehouse

Created by @pkoppishetty


The pipeline pattern moves data from AWS S3 to Snowflake Data Warehouse. The pattern contains a Directory Browser (to retrieve the file list from S3), Snowflake Execute, and Snowflake Bulkload Snaps (to load the corresponding files into Snowflake).

Configuration

File Reader Preview

Snowflake Bulkload Output

snowflakebulkloadoutput

Table Data from Snowflake Select Snap

Tabledatafromsnowflakeselectsnap

Sources: AWS S3
Targets: Snowflake
Snaps used: Snowflake Execute, Directory Broswer, File Reader, Snowflake Bulk Load, Snowflake Select

Downloads

Integration pattern for moving data from AWS S3 to Snowflake datawarehouse.slp (14.2 KB)