dbt: Snowplow 0.3.8

Added the following functionality:

• new optional interface for event data output by Fivetran's snowplow integration
• filter for certain app_ids

dbt: Snowplow 0.3.7

Updated to fix a bug where empty strings were getting inserted into UTM parameter fields when internally referrer sessions were being re-sessionized.

dbt: Snowplow 0.3.6

Updated to use namespaced adapter calls to already_exists() to support the changes coming in next version of dbt.

dbt: snowplow 0.3.5

Updated users table to use inferred_user_id as primary key.

dbt: snowplow 0.3.4

Updated schema tests to use updated ref() calls explicitly. This was a breaking change introduced by dbt 0.8.0.

dbt: snowplow 0.3.3

snowplow data models (0.3.3)

dbt data models for snowplow analytics. Adapted from Snowplow's web model

models

The primary data models contained in this package are described below. While other models exist,
they are primarily used to build the three primary models listed here.

model	description
snowplow_page_views	Contains a list of pageviews with scroll depth, view timing, and optionally useragent and performance data.
snowplow_sessions	Contains a rollup of page views indexed by cookie id (user_snowplow_domain_id)
snowplow_users	Contains a rollup of users with information about their first and last sessions

installation

• add the following lines to the bottom of your dbt_project.yml file:

repositories:
  - "git@github.com:fishtown-analytics/snowplow.git@0.3.3"

• run dbt deps.

configuration

The variables needed to configure this package are as follows:

variable	information	required
snowplow:timezone	Timezone in which analysis takes place. Used to calculate local times.	No
snowplow:events	Schema and table containing all snowplow events	Yes
snowplow:context:web_page	Schema and table for web page context	Yes
snowplow:context:performance_timing	Schema and table for perf timing context, or false if none is present	Yes
snowplow:context:useragent	Schema and table for useragent context, or false if none is available	Yes

An example dbt_project.yml configuration is provided below

# dbt_project.yml

...

models:
    snowplow:
        vars:
            'snowplow:timezone': 'America/New_York'
            'snowplow:events': "{{ ref('sp_base_events') }}"
            'snowplow:context:web_page': "{{ ref('sp_base_web_page_context') }}"
            'snowplow:context:performance_timing': false
            'snowplow:context:useragent': false
    base:
      optional:
        enabled: false
    page_views:
      optional:
        enabled: false

...

repositories:
  - "git@github.com:fishtown-analytics/snowplow.git"

contribution

Additional contributions to this repo are very welcome! Please submit PRs to master. All PRs should only include functionality that is contained within all snowplow deployments; no implementation-specific details should be included.

dbt: snowplow 0.3.0

snowplow data models

dbt data models for snowplow analytics. Adapted from Snowplow's web model

models

The primary data models contained in this package are described below. While other models exist,
they are primarily used to build the three primary models listed here.

model	description
snowplow_page_views	Contains a list of pageviews with scroll depth, view timing, and optionally useragent and performance data.
snowplow_sessions	Contains a rollup of page views indexed by cookie id (user_snowplow_domain_id)
snowplow_users	Contains a rollup of users with information about their first and last sessions

installation

• add the following lines to the bottom of your dbt_project.yml file:

repositories:
  - "git@github.com:fishtown-analytics/snowplow.git"

• run dbt deps.

configuration

The variables needed to configure this package are as follows:

variable	information	required
snowplow:timezone	Timezone in which analysis takes place. Used to calculate local times.	No
snowplow:events	Schema and table containing all snowplow events	Yes
snowplow:context:web_page	Schema and table for web page context	Yes
snowplow:context:performance_timing	Schema and table for perf timing context, or false if none is present	Yes
snowplow:context:useragent	Schema and table for useragent context, or false if none is available	Yes

An example dbt_project.yml configuration is provided below

# dbt_project.yml

...

models:
    snowplow:
        vars:
            'snowplow:timezone': 'America/New_York'
            'snowplow:events': "{{ ref('sp_base_events') }}"
            'snowplow:context:web_page': "{{ ref('sp_base_web_page_context') }}"
            'snowplow:context:performance_timing': false
            'snowplow:context:useragent': false
    base:
      optional:
        enabled: false
    page_views:
      optional:
        enabled: false

...

repositories:
  - "git@github.com:fishtown-analytics/snowplow.git"

contribution

Additional contributions to this repo are very welcome! Please submit PRs to master. All PRs should only include functionality that is contained within all snowplow deployments; no implementation-specific details should be included.

dbt: snowplow 0.2.1

Changelog:

• added new fields

dbt: snowplow 0.2.0

Change log:

Use DBT package conventions -- prefix model names with name of project (snowplow_).

models:

• snowplow_enriched_events
• snowplow_id_map
• snowplow_page_views
• snowplow_sessions
• snowplow_visitors

snowplow dbt models

Models

• snowplow_enriched_events
• id_map
• page_views
• sessions
• visitors