Answer-first summary for fast verification
Answer: GET @%TBL_EMPLOYEE 'file://C:/folder with space/';
The correct answer is B based on Snowflake documentation and community consensus. The GET command is used to download files from a stage to a local directory. For Windows paths with special characters (like spaces), the entire file URI must be enclosed in single quotes, and the path separator must be a forward slash (/), not a backslash (\). Option B follows this syntax correctly: GET @%TBL_EMPLOYEE 'file://C:/folder with space/'. Option A uses backslashes, which is incorrect for enclosed URIs in Snowflake. Options C and D use PUT, which uploads files to a stage, opposite of the required download operation. Community discussion shows B has higher upvotes (67%) and references official documentation confirming the forward slash requirement in enclosed URIs.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which SQL command will download all data files from the internal table stage named TBL_EMPLOYEE to a local Windows directory on the client machine in a folder named "folder with space" located on the C drive?
A
GET @%TBL_EMPLOYEE 'file://C:\folder with space';
B
GET @%TBL_EMPLOYEE 'file://C:/folder with space/';
C
PUT 'file://C:\folder with space*' @%TBL_EMPLOYEE;
D
PUT 'file://C:/folder with space/*' @%TBL_EMPLOYEE;
No comments yet.