Amazon S3 to Snowflake integrationamazon s3 load matillion etl redshift

  • Simple drag-and-drop configuration
  • Supports CSV, delimited, fixed width, JSON and AVRO
  • Schedule data load and transformation and combine with other data, processes and services
  • Use in concert with other components to copy data to S3, then load into Snowflake
  • Export data to S3 from Snowflake tables

High performance Amazon S3 data load into and out of Snowflake

How to Get Started

 

 

Amazon S3 to Snowflake Load Component

The S3 load component in Matillion ETL for Snowflake provides drag-and-drop data load from Amazon S3 into Snowflake.  Easily load CSV, delimited, fixed width, JSON and AVRO data into Snowflake tables, as standalone jobs or as part of sophisticated integration orchestrations.

 

Features and Benefits

The S3 load component in Matillion ETL for Snowflake delivers fast data load performance, with simple drag-and-drop configuration and is extensible to the most sophisticated data load and transform requirements.

  • Fast and simple – load and transform CSV, fixed width, delimited, JSON or AVRO data into Snowflake in a drag-and-drop interface
  • Copy data to S3 from FTP, sFTP, HTTP and HTTPS to S3, then load into Snowflake
  • Supports for encrypted data
  • Supports GZIP, LZop and BZip2 compression
  • Standalone data load or sophisticated integration – combine data held in S3 with data from other databases and systems. Integrate with other AWS services including RDS, SQS and SNS
  • Integrates with Lambda, S3 bucket events and SQS for event-based and real-time integration
  • S3 Unload feature to export data from Snowflake into S3

 

Useful links:

Want to try the Amazon S3 Load component in Matillion ETL for Snowflake?

Arrange a free 1-hour demo, or start a free 14-day trial.