Skip to main content

In the Snowflake Schema -  CLOSE_DATE, CREATED_DATE, & MODIFIED_DATE_LAST are all DATE Format

When I query in Snowflake – I am receiving DATE-formatted data, ie. 2021-01-28

When I add this OBJECT in the SNOWFLAKE CONNECTOR – those 3 fields are showing a data type of “date-time”

I have tried to ingest that data into a destination of an MDA Object with the fields formatted as DATE on the MDA object and no values come over for these fields and then formatted as DATE-TIME on the MDA Object, no values come over for these fields.

It appears I cannot change the field type on the object when I add it to the snowflake connector.

Has anyone seen anything similar and/or have any guidance?

@waynedilworth Can confirm that it doesn’t look like you can change the field type when you add it.

Reply


Terms & ConditionsCookie settings