[Bug] make sure timestamps do not have time zones

[fivetran-jamie]

Is there an existing issue for this?

• I have searched the existing issues

Describe the issue

reported by @calder-holt

in the transform package we're seeing dateadd-related issues because activity_timestamp is getting piped in as a timestamp with time zone (on redshift). similar to our other packages, we'll need to cast this field as {{ dbt_utils.type_timestamp() }} (aka timestamp without time zone) preemptively

Relevant error log or model output

No response

Expected behavior

date functions shouldn't fail and the timestamps shouldn't have time zones

dbt Project configurations

na

Package versions

na

What database are you using dbt with?

redshift

dbt Version

na

Additional Context

No response

Are you willing to open a PR to help address this issue?

• Yes.
• Yes, but I will need assistance and will schedule time during our office hours for guidance
• No.

[fivetran-joemarkiewicz]

This issue has been addressed in the PR merged above.