Data sources with different timezones being loaded into Snowflake

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_tz and 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!

1 Like