This PR introduces a fix for redshift users who have their timestamps being currently synced as timestamptz. The fix will explicitly cast the timestamp as timestamp without time zone to allow for downstream date functions to not error out. I did confirm that casting the timestamptz date to timestamp without time zone does not alter the data but instead changes its interpretation.
Does this PR introduce a breaking change?
[ ] Yes (please provide breaking change details below.)
[X] No (please provide explanation how the change is non breaking below.)
This will only modify how the relevant timestamp fields are interpreted within redshift and will not result in a breaking change.
Is this PR in response to a previously created Issue
[X] Yes, Issue #23
[ ] No
How did you test the PR changes?
- [ ] CircleCi
- [ ] Other (please provide additional testing details below)
**Select which warehouse(s) were used to test the PR**
- [X] BigQuery
- [X] Redshift
- [X] Snowflake
- [X] Postgres
- [ ] Databricks
- [ ] Other (provide details below)
**Provide an emoji that best describes your current mood**
⌚
**Feedback**
We are so excited you decided to contribute to the Fivetran community dbt package! We continue to work to improve the packages and would greatly appreciate your [feedback](https://www.surveymonkey.com/r/DQ7K7WW) on our existing dbt packages or what you'd like to see next.
Are you a current Fivetran customer?
Fivetran created PR
What change(s) does this PR introduce?
This PR introduces a fix for
redshiftusers who have their timestamps being currently synced astimestamptz. The fix will explicitly cast the timestamp astimestamp without time zoneto allow for downstream date functions to not error out. I did confirm that casting thetimestamptzdate totimestamp without time zonedoes not alter the data but instead changes its interpretation.Does this PR introduce a breaking change?
This will only modify how the relevant timestamp fields are interpreted within
redshiftand will not result in a breaking change.Is this PR in response to a previously created Issue
How did you test the PR changes?
- [ ] CircleCi - [ ] Other (please provide additional testing details below) **Select which warehouse(s) were used to test the PR** - [X] BigQuery - [X] Redshift - [X] Snowflake - [X] Postgres - [ ] Databricks - [ ] Other (provide details below) **Provide an emoji that best describes your current mood** ⌚ **Feedback** We are so excited you decided to contribute to the Fivetran community dbt package! We continue to work to improve the packages and would greatly appreciate your [feedback](https://www.surveymonkey.com/r/DQ7K7WW) on our existing dbt packages or what you'd like to see next.