A user has unloaded data from Snowflake to a stage Which SQL command should be used to validate which data was loaded into the stage?

The correct answer is A. list @file__stage. In Snowflake, the LIST command (abbreviated as LS) is the correct SQL command to display files currently stored in an internal or external stage. The syntax 'LIST @stage_name' (or 'LS @stage_name') returns file names, sizes, MD5 checksums, and last-modified timestamps for all…

Data Loading and Unloading

Question

Options

Alist @file__stage
Bshow @file__stage
Cview @file__stage
Dverify @file__stage

How the community answered

(15 responses)

A
93% (14)
D
7% (1)

Explanation

In Snowflake, the LIST command (abbreviated as LS) is the correct SQL command to display files currently stored in an internal or external stage. The syntax 'LIST @stage_name' (or 'LS @stage_name') returns file names, sizes, MD5 checksums, and last-modified timestamps for all files in the specified stage. This is the appropriate way to verify what data was unloaded into a stage after a GET_DDL or COPY INTO @stage operation. SHOW (B) is a valid Snowflake command but is used for listing Snowflake objects like tables, databases, and roles-not for listing files in a stage. VIEW (C) and VERIFY (D) are not valid Snowflake SQL commands for inspecting stage contents.

Topics

#Snowflake stages#Data unloading#LIST command#File management

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice