[BUG] Ghost record generation problem with timestamp data types for load_datetime and effective_from columns

[mjahammel]

Describe the bug
When the target is Snowflake, if the staging view uses the datatype TIMESTAMP_TZ for the load_datetime and effective_from columns, then the ghost record generation fails with the following error:

17:00:24    001790 (42601): SQL compilation error:
17:00:24    inconsistent data type for result columns for set operator input branches, expected TIMESTAMP_TZ(9), got TIMESTAMP_NTZ(9) for expression [{2}] branch {3}

Versions
dbt: 1.3.0
dbtvault: 0.9.1
target: Snowflake

To Reproduce
Steps to reproduce the behavior:

1. Set up staging view in such a way that either the load_datetime and/or the effective_from columns have the datatype TIMESTAMP_TZ
2. Set up a satellite to automatically generate the ghost record
3. Run dbt to create the satellite table.
4. See error

Expected behavior
A satellite table should be created with a ghost record.

A work-around for now is to change the timestamp in the staging view to TIMESTAMP_NTZ.

[DVAlexHiggs]

Released v0.9.2, this should be fixed :) Please re-open if you continue to have the same issue, or open a new issue if you experience any new issues. Thank you for this report!