Why data loading is the warehouse foundation in Snowflake - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to load data from a file into a Snowflake table.

Snowflake

COPY INTO my_table FROM @my_stage/[1] FILE_FORMAT = (TYPE = 'CSV');

Drag options to blanks, or click blank then click option'

Adata.csv

Bmy_table

Cmy_stage

Dfile.csv

Attempts:

3 left

💡 Hint

Common Mistakes

Using the table name instead of the file name.

Using the stage name instead of the file name.

The COPY INTO command loads data from a file in the stage. The file name must be specified, here it is data.csv.

2fill in blank

medium

Complete the code to specify the file format for loading JSON data.

Snowflake

CREATE OR REPLACE FILE FORMAT my_json_format TYPE = '[1]';

Drag options to blanks, or click blank then click option'

AJSON

BCSV

CPARQUET

DXML

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing CSV or PARQUET when data is JSON.

Using XML which is not supported here.

The file format type must match the data format. For JSON data, use JSON.

3fill in blank

hard

Fix the error in the command to load data into the warehouse.

Snowflake

COPY INTO [1] FROM @my_stage FILE_FORMAT = (TYPE = 'CSV');

Drag options to blanks, or click blank then click option'

Amy_stage

Bmy_database

Cmy_table

Ddata.csv

Attempts:

3 left

💡 Hint

Common Mistakes

Using the stage name instead of the table name.

Using the file name instead of the table name.

The COPY INTO command must specify the target table, not the stage or file name.

4fill in blank

hard

Fill both blanks to create a stage and load data from it.

Snowflake

CREATE OR REPLACE STAGE [1] URL='s3://mybucket/data/' FILE_FORMAT = (TYPE = '[2]');

Drag options to blanks, or click blank then click option'

Amystage

BCSV

Cmytable

DJSON

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing table name with stage name.

Using wrong file format type.

The stage name is mystage and the file format type is CSV to match the data files.

5fill in blank

hard

Fill all three blanks to load data with error handling options.

Snowflake

COPY INTO [1] FROM @[2] FILE_FORMAT = (TYPE = 'CSV') ON_ERROR = '[3]';

Drag options to blanks, or click blank then click option'

Amy_table

Bmystage

Cskip_file

Dabort_statement

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up stage and table names.

Using incorrect error handling options.

The target table is my_table, the stage is mystage, and abort_statement stops loading on errors.