Hi there,
I'm trying to write to Snowflake using Beam, it writes down the CSV where a
row looks like this:
'test','123','2021-05-28','','true'
I see that everything is quoted with a single quote (') by default, which
is fine, and confirms what I read in the documentation of withQuotationMark.
I have a few columns that are nullable, and for a given null value I see:
''.
However I'm getting errors when the process tries to COPY INTO Snowflake,
even though the columns are nullable, it complains about getting two single
quotes ''.
[info] at
org.apache.beam.sdk.io.snowflake.SnowflakeIO$CopyToTableFn.processElement(SnowflakeIO.java:1273)
[info] 2021-07-19T17:49:00++0100 [ERROR:main] 2021-07-19T16:48:59.109Z:
net.snowflake.client.jdbc.SnowflakeSQLException: Date '' is not recognized
Is there some option I'm missing?
Best regards
Daniel
