Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

NOTE: Date values without time information from

D s item
itemData Type

SupportedSnowflake TypeNotes

Array

N 
BoolYBOOLEAN
DateYTIMESTAMP
Info
D s product
are written to Snowflake as Datetime values. This is a known issue.

See below.

DatetimeYTIMESTAMP
TimeYTIME
FloatYFLOAT
IntegerYBIGINT
MapN 
StringYVARCHAR

Notes on Date publishing:


Info

NOTE:

D s item
itemDate columns
can be published to existing Snowflake columns of Date, Datetime, and String type.

When Dates are published to Snowflake, the following date formats are supported. In some cases, missing data is inserted into the output value.

D s item
itemdate format

Snowflake date format

yy-dd-mm

yy-dd-mm
yy-mm-ddyy-mm-dd
dd-mm-yydd-mm-yy
mm-dd-yymm-dd-yy
mm-yymm-yy
dd-mm1970-dd-mm
mm-dd1970-mm-dd
mm-yymm-yy-01
  • On publication, all dates are written in the following format: yyyy-mm-dd
  • No other date formats are supported for writing to Snowflake as date values.