Explanation:
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.
Ultimate access to all questions.
No comments yet.
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;