Answer-first summary for fast verification
Answer: Use the GET_STAGE_LOCATION function.
The GET_STAGE_LOCATION function is specifically designed to return the location of a stage, including the URL of the directory table for external stages. This function directly addresses the requirement to extract the URL for further transformation or data processing. The community discussion shows 100% consensus on option D, with multiple users confirming this is correct and referencing Snowflake documentation. Other options are less suitable: SHOW STAGES lists available stages but doesn't provide specific URLs; DESCRIBE STAGE shows stage properties but not the directory table URL; GET_ABSOLUTE_PATH is not a valid Snowflake function for this purpose.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can a Snowflake user retrieve the URL of a directory table that is on an external stage for subsequent data processing?
A
Use the SHOW STAGES command.
B
Use the DESCRIBE STAGE command.
C
Use the GET_ABSOLUTE_PATH function.
D
Use the GET_STAGE_LOCATION function.
No comments yet.