Tutorial: Bulk Loading 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 tutorial covers loading of both CSV and JSON data.

Interface

SnowSQL (CLI Client)

Est. Time

20-30 minutes

Est. Credits

< 1

Before You Begin:

Steps: