Tutorial: Loading Data from Amazon S3 Using COPY

This tutorial describes how to load data from files in an existing Amazon Simple Storage Service (Amazon S3) bucket into a table. In this tutorial, you will learn how to:

  • Create named file formats that describe your data files.
  • Create named stage objects.
  • Load data located in your S3 bucket into Snowflake tables.
  • Resolve errors in your data files.

The instructions include steps for loading either CSV or JSON data.

Interface:SnowSQL (CLI Client)
Est. Time:20-30 minutes
Est. Credits:< 1

Before You Begin:

Next Steps: