Tutorial: Loading Basic CSV Files from a Local File System Using COPY

This tutorial describes the fundamental steps to load data from flat files into Snowflake using the COPY command. This tutorial assumes the following:

  • Your data is stored in comma-delimited files.
  • You are using a Snowflake-provided stage to “stage” your data files (i.e. make the files available to Snowflake for loading).
  • Your data contains no errors.

For more complex loading scenarios, see the other data loading tutorials provided in the documentation.

Interface:SnowSQL (CLI Client)
Est. Time:10-15 minutes
Est. Credits:1

Before You Begin:

Next Steps: