ETL Amazon S3 data to Snowflake

About Amazon S3

Experience Reliability & Scalability With AWS Online Storage Solutions. Sign Up For Free! Enforce Data Access Controls, Secure Against Unauthorized Users & Run Big Data Analytics. In-Memory Caching. Secure Solutions. Highly Scalable. No Upfront Commitment.

Learn more about Amazon S3.

Choose what data you would like to move from Amazon S3

CSV Data Report

This pipeline can be used to request and retrieve CSV files/folders (consisting similar structured CSV files). The transfer is enabled irrespective of whether CSV files are compressed or not.

JSON Data Report

This pipeline can be used to request and retrieve JSON files/folders (consisting similar structured JSON files). The transfer is enabled irrespective of whether JSON files are compressed or not.

Excel Data Report

This pipeline can be used to request and retrieve Excel files/folders (consisting similar structured Excel files). The transfer is enabled irrespective of whether Excel files are compressed or not.

Learn more about what data can be integrated into your data warehouse using DataChannel in the documentation here.

‍

Steps to Integrate Amazon S3 with Snowflake using DataChannel

From the DataSources section select Amazon S3 as the data source.
Select your added Snowflake data warehouse as the data destination. If you have not yet added a data warehouse, go to Data Warehouse tab and add a warehouse.
Authorize DataChannel to connect to your S3 Bucket account using the + icon with your Access Key, Secret Key, Bucket Name & AWS Location.
Click on + Data Pipeline to start adding data pipelines to your account.