SnowPro Associate Platform SOL-C01

By Snowflake · Question Mode

QuestionQ17

Load and leverage structured, semi-structured, and unstructured data

What is the purpose of this SQL command in Snowflake?

COPY INTO table_name FROM @stage_name FILE_FORMAT = (FORMAT NAME = ‘csv_format");

Explanation

COPY INTO <table> loads data files from a stage into the specified target table. The named CSV file format tells Snowflake how to parse the source file data during that load. Snowflake: Copy data from an internal stage

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!