TimeZone Change For Data Ingested from Snowflake to Domo

qzqzqzqzqz
qzqzqzqzqz Member
in Connectors

I set up a Snowflake Connector to pull a dataset from Snowflake. There are a few variables with timestamp. The time displayed in Snowflake is ETC. However, when it displayed in Domo, it looks it automatically adjusted to a different time zone. Is this expected? How does Domo adjust variables with timestamp? Can I update the setting so that it keeps the EST time zone in Domo?

Tagged:

Answers

  • MichelleH
    MichelleH Coach

    @qzqzqzqzqz Domo will attempt to convert your datetime fields into the time zone in your instance's Company Settings, so it's likely trying to convert to the default UTC. If you decide to change this setting, do so with caution to avoid disruption to your existing content. Otherwise, there are options in Magic ETL to convert time zones for that specific dataset.

  • qzqzqzqzqz
    qzqzqzqzqz Member

    @MichelleH Thank you! However, when I pull data directly out of Salesforce, it pulls the timestamp as is. Why is there a difference between where the data is exacted from?

  • MichelleH
    MichelleH Coach

    @qzqzqzqzqz Different systems may have different settings. Snowflake may be storing your datetime fields with a time zone, while Salesforce does not.

Categories