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?
