snowplow / data-models

⚠️ MAINTENANCE-ONLY MODE: Snowplow maintained SQL data models for working with Snowplow web and mobile behavioral data.
https://docs.snowplowanalytics.com/docs/modeling-your-data/
41 stars 12 forks source link

Redshift Web: load_tstamp missing from table definition #135

Closed agnessnowplow closed 2 years ago

agnessnowplow commented 2 years ago

From RDB Loader v4.0.0 onwards, load_tstamp is added to the events table. This breaks the Redshift models at the insert step, where the events_staged table gets populated:

    INSERT INTO {{.scratch_schema}}.events_staged{{.entropy}} (
    SELECT * FROM {{.scratch_schema}}.events_this_run{{.entropy}}

The new column should be added to the table definitions for events_staged to avoid the INSERT has more expressions than target columns issue.