Data Loading/Functions - 7

●You are loading a table named my_table

●The files you want to load are on the TABLE stage

●You've created a file format called my_csv

What COPY INTO command will you use?

• COPY INTO

    my_table

  FROM

    @%my_table

  FILE_FORMAT =

    (FORMAT_NAME = my_csv);

• COPY INTO

    my_table

  FROM

    @my_table

  FILE_FORMAT =

  CSV

• COPY INTO

    table

  FROM

    @%my_table

  FILE_FORMAT =

    (FORMAT_NAME = my_csv);

What does a file format do?

• Format the data as it is being written to the table.

• Describe how to read the input file.

• Read the file into Snowflake

TRUE OR FALSE?

Metadata for micro-partitions is created only when you load data from an internal stage.

• TRUE

• FALSE

Answer explanation

Metadata for micro-partitions is always created, even if you load data from an external stage, or use other methods (such as INSERT or CTAS) to add data to a table.

Which of the following statements about stages are TRUE?

• A stage is a cloud file repository.

• A stage can be internal or external.

• Stages disappear as soon as all their files are loaded.

• You can manually create named stages, user stages, or table stages.

Which of the following statements about file formats are TRUE?

• File formats store data of a particular type

• A file format stores information needed to parse input files for loading.

• You must specify a file format as part of every COPY INTO command.

• The default file format is CSV.

Does this command use an internal stage, or an external stage?

COPY INTO

  my_table

FROM

  @my_stage

• internal

• external

• neither

• you can't tell!

Answer explanation

You can't tell.  It's a named stage, which could be either external or internal

TRUE OR FALSE?

This command will load data from a named stage:

COPY INTO my_table

FROM @%my_table;

Answer explanation

The command is loading data from a table stage.  You can tell from the prefix:

@<stage name> = named stage

@%<table name> = table stage

@~ = user stage