In the command referencing an internal stage @xf_tuts.public.%emp_raw from a Put command, which internal stage name is indicated by the percent sign?

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

In the command referencing an internal stage @xf_tuts.public.%emp_raw from a Put command, which internal stage name is indicated by the percent sign?

Explanation:
The percent sign in a stage reference marks a per-table stage, meaning a table-level internal stage for that specific table. In @xf_tuts.public.%emp_raw, xf_tuts is the database, public is the schema, and %emp_raw designates the table’s own internal stage for the table named emp_raw. So, the internal stage indicated by the percent sign is a TABLE (table-level) stage. The database and schema parts come before the percent sign, while the percent sign itself signals the table-level scope.

The percent sign in a stage reference marks a per-table stage, meaning a table-level internal stage for that specific table. In @xf_tuts.public.%emp_raw, xf_tuts is the database, public is the schema, and %emp_raw designates the table’s own internal stage for the table named emp_raw. So, the internal stage indicated by the percent sign is a TABLE (table-level) stage. The database and schema parts come before the percent sign, while the percent sign itself signals the table-level scope.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy