Tutorial: Bulk loading from a local file system using COPY

This tutorial describes how to load data from files in your local file system into a table.

You will learn how to:

  • Create named file format objects that describe your data files.

  • Create named stage objects.

  • Upload your data to the internal stages.

  • Load your data into 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: