Hi Stitch Community!
On Stitch Documentation for snowflake data loading, it’s written for timestamps that
Snowflake will store the data as
TIMESTAMP WITH TIMEZONE, or
timestamp_tzand adjust to show as UTC.
In my case, I use America/Sao_Paulo timezone and I have sources whose tables have columns of type ‘timestamp without timezone’, and Stitch is always loading as UTC time.
In the future, we might have also a source database on other timezone, whose timestamp columns are of type ‘timestamp_without_timezone’ as well.
Is there any plan in the future for the
Stitch integration with Snowflake as destination to be more versatile, in terms of:
- I can decide whether Stitch will load datetime columns in format other than default (e.g. TIMESTAMP_NTZ)
- I can set the timezone of a certain data source on Stitch (then, Stitch loads into Snowflake
2019-06-01 12:00:00 -0300[correct] instead of
2019-06-01 12:00:00 +0000[wrong])
That would ease our life a lot!