Amazon S3

Learn the steps for ingesting your Amazon S3 data into your target.

Steps

1. Configure access to your source Amazon S3 location.

2. Create a connection to your source Amazon S3 location.

3. Create a connection to your target (see the Supported Targets list below for links).

4. Create the entities for your target per the list in the Job Type & Steps column below. Note that there are multiple options for ingesting to Snowflake:

Job Type & Steps	Supported Targets
Ingestion Job Create a staging table in the data lake Create an ingestion job to load data into the staging table Create a transformation job for each target	Amazon Redshift AWS Glue Data Catalog ClickHouse Elasticsearch Polaris Catalog PostgreSQL Snowflake
Direct Ingestion Job Create an ingestion job to load directly into the target	Snowflake

No-code Wizard

Alternatively, you can use the Upsolver no-code Wizard to get your pipelines started in super-quick time. The Wizard generates the code for you so you can optionally customize it for your requirements, and create advanced use cases.

---

Related Content

Quickstarts

• Create an Amazon S3 Connection

• Ingest Your Data from Amazon S3

• Output to Amazon S3

How To Guides

• Create and Maintain Connections to Your Amazon S3 Bucket
• Configure Access to Amazon S3
• Real-time Data Ingestion — Amazon S3 to Amazon Athena
• Joining Data — Amazon S3 to Amazon Athena
• Upserting Data — Amazon S3 to Amazon Athena

Reference

• Connection Options for Amazon S3

• Ingestion Job Options for Amazon S3