If external software i.e. TIBCO, exports Data fields enclosed in quotes but inserts a leading space before the opening quotation character for each field, How Snowflake handle it? [Select 2]

Question

Web Administrator · Accepted Answer

COPY command trims the leading space and removes the quotation marks enclosing each field

Web Administrator · Answer

Snowflake automatically handles leading spaces by trimming implicitly & removes the quotation marks enclosing each field.

Web Administrator · Answer

field_optionally_enclosed_by option along with TRIM_IF function in COPY INTO statement can be used to handle this scenario successfully.

Web Administrator · Answer

Snowflake reads the leading space rather than the opening quotation character as the beginning of the field and the quotation characters are interpreted as string data.(Correct)

Web Administrator · Answer

copy into SFtable

Web Administrator · Answer

from @%SFtable

Web Administrator · Answer

file_format = (type = csv trim_space=true field_optionally_enclosed_by = '0x22');

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 74 - DEA-C01 discussion

Suggested answer: D

0 comments