From what stage can a Snowflake user omit the FROM clause while loading data into a table?

The correct answer is B. The table stage. When loading from a table stage, Snowflake implicitly knows the source because each table has exactly one associated table stage named @%<table_name>. Since the target table and the stage share the same name, you can simply run 'COPY INTO mytable;' without specifying a FROM…

Data Loading and Unloading

Question

Options

AThe user stage
BThe table stage
CThe internal named stage
DThe external named stage

How the community answered

(21 responses)

A
5% (1)
B
90% (19)
C
5% (1)

Explanation

When loading from a table stage, Snowflake implicitly knows the source because each table has exactly one associated table stage named @%<table_name>. Since the target table and the stage share the same name, you can simply run 'COPY INTO mytable;' without specifying a FROM clause. For user stages (@~), internal named stages (@my_stage), and external named stages, Snowflake cannot infer the source, so the FROM clause is required.

Topics

#Data Loading#COPY INTO command#Table Stage#FROM clause

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice