SOL-C01 practice question 5 of 30

Which command is synonymous with the LIST command in Snowflake?

Full set: 214 questions
Answer options
A: LS Correct answer
B: SHOW
C: DESC
D: LIS
Correct Answer:
A. LS
Explanation

Snowflake defines LS as an exact synonym (alias) of the LIST command for enumerating staged files; both commands share identical syntax and behaviour.

Why Incorrect

B. SHOW is a family of metadata commands, not an alias for LIST.
C. DESC (or DESCRIBE) is used for describing objects, not listing stage contents.
D. LIS is not a recognised Snowflake command.

References

1. Snowflake Documentation – “LIST Command”, note: “Synonym: LS” (docs.snowflake.com, §Syntax, accessed 2024-04-24).

2. Snowflake Documentation – “Commands Not Covered by the SQL Parser” (docs.snowflake.com, confirms command aliases).

Scroll to Top