Tutorial: Loading Data from a Local File System Using COPY

This tutorial describes how to load data from files in an internal Snowflake stage into a table.

You will learn how to:

  • Create named file formats that describe your data files.
  • Create named stage objects.
  • Stage your data files to internal Snowflake stages.
  • Load your data into Snowflake tables.
  • Resolve errors in your data files.

The instructions include steps for loading both CSV and JSON data.

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

Before You Begin:

Next Steps: