CODEWITHSUNDEEP
asciidelimitersnowflake-cloud-data-platformfile-format
keyaar
keyaar

Reputation: 23

Creation of file-format in Snow-flake

I am new to SF. I have a typical problem that I have faced while loading some data. The delimiter is part of extended ascii. It does not come in 0-127. We use thorn (ascii - 254) as delimiter. My Qn is while specifying the delimiter can I give the ascii code of that delimiter instead of actual character (44 instead of comma, 9 instead of tab etc)

Thanks in advance

Upvotes: 0

Views: 349

Answers (1)

Simon D
Simon D

Reputation: 6229

You can specify the hex/octal code of any valid Unicode delimiter in the FIELD_DELIMITER option of the File Format. From the documentation:

The specified delimiter must be a valid UTF-8 character and not a random sequence of bytes.

For example, for fields delimited by the thorn (Þ) character, specify the octal (\336) or hex (0xDE) value. Also accepts a value of NONE.

Upvotes: 1

Related Questions