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: