dbt: snowplow 0.9.0

Breaking changes

• This package now requires dbt>=0.16.0 and dbt-utils>=0.2.5
• Database-specific implementations of Snowplow models primarily use the enabled model config and a simple macro is_adapter to turn them on or off based on the current run target. This is preferable to storing all model SQL in adapter macros, as it improves code transparency and clarity of documentation. As such, some models have moved directories, and methods of "overriding" models from the Snowplow package have changed slightly.

Features

• Full native Postgres support. Postgres is now included in CI.
• Support for 0.16.0 changes to partition_by and incremental models on BigQuery. User can override the incremental_strategy and partitions (if >=0.16.1) configs of Snowplow models in their root dbt_project.yml.

Under the hood

• More consistent incremental filtering logic via an adapter macro, get_start_ts

Quality of life

• Full source code for models appears in documentation (in lieu of config and macro call)
• Added documentation for all seeds and macros

dbt: snowplow 0.8.2

Changes

• Improve useragent filtering that removes bot page views (#75, #81)
• Change tests that frequently fail at scale to warn severity by default (#80)

Fixes

• Jinja-generated whitespace in BigQuery snowplow_page_views (#82)
• Remove unused macros (#83)

Contributors

• @Selvaticus

dbt: snowplow 0.8.1

Fixes

• Remove unique test on snowplow_base_events.event_id (#73)

dbt: snowplow 0.8.0

Breaking changes

• Remove session mapping for "internal" referred sessions (#58). N.B. This will result in more rows in snowplow_session, and higher overall session counts.
• Speed up snowplow_page_views incremental runs by limiting its look-back window to a configurable number of days (default = 1) (#71)

Contributors:

• @sphinks (#71)

dbt: snowplow 0.7.5

Fixes:

• Expand default performance timing types from int to bigint (#66, #67)

Contributors:

• @sphinks (#67)

dbt: snowplow 0.7.4

• Add basic browser fields to models when useragent context is disabled (#63)
• Rename CTEs to workaround Snowflake query compilation bugs (#63)
• Update README with better installation instructions (#64)
• Fix for integration tests (#65)

Contributors:

• @tayloramurphy (#63)

dbt: snowplow 0.7.3

• Working integration tests on BigQuery (#51)
• Add pass_through_cols as config variable, similar to Segment package (#53)
• Issue backlog, general cleanup (#57)
• Update README (#61)

Contributors:

• @emilieschario

dbt: snowplow 0.7.2

Fix Big Query adapter:

• Changed collector_tstamp casting to cast(collector_tstamp as timestamp)
• Changed the session roll-up in snowplow_page_views to be based on page_view_in_session_index

dbt: snowplow 0.7.1

• Fix for duplicated sessions when late arriving facts are received (#49)

dbt: snowplow 0.7.0

• use is_incremental() in all incremental models
• remove sql_where to bypass deprecation warning
• fix for logic error in session index calculation when sessions cross a run boundary