COPY INTO command in Snowflake - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of the COPY INTO command in Snowflake?

The COPY INTO command loads data from files in external or internal stages into Snowflake tables. It helps move data efficiently into the database.

beginner

Which file formats can COPY INTO handle in Snowflake?

It supports common formats like CSV, JSON, Parquet, Avro, and ORC files for loading data.

beginner

What is a 'stage' in the context of the COPY INTO command?

A stage is a location where data files are stored before loading. It can be internal (inside Snowflake) or external (like AWS S3, Azure Blob Storage).

intermediate

How does Snowflake handle errors during a COPY INTO operation?

You can specify options like ON_ERROR to control behavior: skip errors, continue loading, or abort the operation.

beginner

What does the FILE_FORMAT option do in the COPY INTO command?

It tells Snowflake how to interpret the data files by specifying the format type and related settings like delimiter or compression.

What does the COPY INTO command do in Snowflake?

A Exports data from tables to files

B Loads data from files into tables

C Deletes data from tables

D Creates new tables

The COPY INTO command loads data from files into Snowflake tables.

Where can the source files be located for the COPY INTO command?

A Only internal Snowflake stages

B Only external cloud storage

C Internal or external stages

D Only local computer

Files can be in internal or external stages like S3 or Azure Blob Storage.

Which option controls how errors are handled during COPY INTO?

A ON_ERROR

B FILE_FORMAT

C STAGE_LOCATION

D DATA_RETENTION_TIME

ON_ERROR specifies what to do if errors occur during loading.

What does the FILE_FORMAT option specify?

A How to read the input files

B The cloud provider

C The destination table

D The user permissions

FILE_FORMAT tells Snowflake how to interpret the data files.

Which of these is NOT a supported file format for COPY INTO?

A CSV

B JSON

C Parquet

D Excel XLSX

Snowflake does not natively support Excel XLSX files for COPY INTO.

Explain how the COPY INTO command works in Snowflake and what key options you can use.

Think about where files come from, how Snowflake reads them, and what happens if errors occur.

Describe the difference between internal and external stages in the context of the COPY INTO command.

Consider where your data files live before loading.