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 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, 10 months agokayuhanbiduk
Highly Voted 1 year, 6 months agonehanovigo
Most Recent 8 months, 2 weeks agoRameez1
10 months, 1 week agonexerSnow
1 year, 2 months agoValcon_doo
1 year, 5 months agoASK_123
1 year, 6 months agoPradeep_7869
1 year, 6 months agoHeetec
1 year, 6 months agojAtlas7
1 year, 7 months agosid1604
1 year, 7 months agoJG1984
1 year, 8 months agosinghks
1 year, 8 months agoZMF_2023
1 year, 7 months agoMarcusbraga
1 year, 9 months agoEitan
1 year, 10 months ago