Which SQL command will download all the data files from an internal table stage named TBL_EMPLOYEE to a local window directory or folder on a client machine in a folder named folder with space within 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;
https://docs.snowflake.com/en/sql-reference/sql/get#required-parameters
Windows:-You must include the drive and backslash in the path (e.g. file://C:tempload).
If the directory path includes special characters, the entire file URI must be enclosed in single quotes. Note that the drive and path separator is a forward slash (/) in enclosed URIs (e.g. 'file://C:/temp/load data' for a path in Windows that includes a directory named load data).
B is correct.
Syntax: GET internalStage file://<local_directory_path>
[ PARALLEL = <integer> ]
[ PATTERN = '<regex_pattern>'' ]
You must include the drive and backslash in the path (e.g. file://C:tempload).
If the directory path includes special characters, the entire file URI must be enclosed in single quotes. Note that the drive and path separator is a forward slash (/) in enclosed URIs (e.g. 'file://C:/temp/load data' for a path in Windows that includes a directory named load data).
The internal stage is @%TBL_EMPLOYEE, which is the stage for the table named TBL_EMPLOYEE. The local directory path is file://C:\folder with space\. The space in the folder name must be escaped with a backslash (\).
https://docs.snowflake.com/en/sql-reference/sql/get
If the directory path includes special characters, the entire file URI must be enclosed in single quotes. Note that the drive and path separator is a forward slash (/) in enclosed URIs (e.g. 'file://C:/temp/load data' for a path in Windows that includes a directory named load data).
A is correct
https://docs.snowflake.com/en/user-guide/data-unload-snowflake#
upvoted 2 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
MultiCloudIronMan
Highly Voted 1 year, 4 months agonehanovigo
Most Recent 2 months, 3 weeks agoRameez1
4 months, 1 week agonexerSnow
9 months agoValcon_doo
12 months agoASK_123
1 year agoPradeep_7869
1 year agoHeetec
1 year, 1 month agokayuhanbiduk
1 year, 1 month agojAtlas7
1 year, 1 month agosid1604
1 year, 1 month agoJG1984
1 year, 2 months agosinghks
1 year, 3 months agoZMF_2023
1 year, 1 month agoMarcusbraga
1 year, 3 months agoEitan
1 year, 4 months ago