Adding escape sequence for space in Snowflake PUT command

Question

I have been trying to load a file into Snowflake using PUT but I am getting an error due to space in the folder name.

PUT file://Y:/AMI Control/file.csv  @MS_FILE_LND
AUTO_COMPRESS=FALSE

I have tried using \ escape sequence and enclosing the entire path in quotes but it doesn't seem to be working.

score 6 · Accepted Answer · answered Jul 14 '20 at 08:32

6

This would work

For Linux/Mac:

PUT 'file:///AMI Control/file.csv'  @MS_FILE_LND AUTO_COMPRESS=FALSE

For Windows:

PUT 'file://Y:\AMI Control\file.csv'  @MS_FILE_LND AUTO_COMPRESS=FALSE

answered Jul 14 '20 at 08:32

Iqra Ijaz

261
1
3

score 6 · Answer 2 · edited Mar 24 '21 at 12:12

6

The Windows version is incorrect. The correct PUT statement is:

PUT 'file://Y:/AMI Control/file.csv' @MS_FILE_LND AUTO_COMPRESS=FALSE

Snowflake documentation says:

"The URI can be enclosed in single quotes, which allows special characters, including spaces, in directory and file names; however, the drive and path separator is a forward slash (/) for all supported operating systems (e.g. 'file://C:/temp/load data' for a path in Windows containing a directory named load data)."

https://docs.snowflake.com/en/sql-reference/sql/put.html

edited Mar 24 '21 at 12:12

blackgreen

34,072
23
111
129

answered Mar 23 '21 at 17:37

jhowa1

122
1
5

The forward slashes / in your Windows example worked for me, FYI, thanks! – Ward W Jan 13 '22 at 00:13

Adding escape sequence for space in Snowflake PUT command

2 Answers2