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: