The Fivetran Pendo connector stores valid_through/validThrough as type TIMESTAMP WITH TIMEZONE in Redshift. Convert it to TIMESTAMP WITH NO TIMEZONE before calculating a date difference.
Does this PR introduce a breaking change?
[ ] Yes (please provide breaking change details below.)
[ ] No (please provide explanation how the change is non breaking below.)
Not sure.
Is this PR in response to a previously created Issue
[x] Yes, #9
[ ] No
How did you test the PR changes?
- [ ] CircleCi
- [x] Other (please provide additional testing details below)
I ran it against my DWH.
**Select which warehouse(s) were used to test the PR**
- [ ] BigQuery
- [x] Redshift
- [ ] Snowflake
- [ ] Postgres
- [ ] Databricks
- [ ] Other (provide details below)
What change(s) does this PR introduce?
The Fivetran Pendo connector stores
valid_through
/validThrough
as typeTIMESTAMP WITH TIMEZONE
in Redshift. Convert it toTIMESTAMP WITH NO TIMEZONE
before calculating a date difference.Does this PR introduce a breaking change?
Not sure.
Is this PR in response to a previously created Issue
How did you test the PR changes?
- [ ] CircleCi - [x] Other (please provide additional testing details below) I ran it against my DWH. **Select which warehouse(s) were used to test the PR** - [ ] BigQuery - [x] Redshift - [ ] Snowflake - [ ] Postgres - [ ] Databricks - [ ] Other (provide details below)