Skip to main content


Upgrading to 0.3.0โ€‹

  • Version 1.4.0 of dbt-core now required
  • You must add the following to the top level of your project yaml
    - macro_namespace: dbt
    search_order: ['snowplow_utils', 'dbt']
  • Other changes required by snowplow-utils version 0.14.0

Upgrading to 0.2.0โ€‹

  • Version 1.3.0 of dbt-core now required
  • Upgrading your config file
    • Change the event_name field to event_names and make the value a list
    • Change the self_describing_event_schema field to self_describing_event_schemas and make the value a list
    • If you wish to make use of the new features, see the example config or the docs for more information
  • Upgrading your models (preferred method is to re-run the python script, but can be done manually following these steps)
    • For each normalized model:
      • Convert the event_name and sde_cols fields to lists, and pluralize the names in both the set and the macro call
      • Add a new field, sde_aliases which is an empty list, add this between sde_types and context_cols in the macro call
    • For your filtered events table:
      • Change the unique_key in the config section to unique_id
      • Add a line between the event_table_name and from lines for each select statement; , event_id||'-'||'<that_event_table_name>' as unique_id, with the event table name for that select block.
    • For your users table:
      • Add 3 new values to the start of the macro call, 'user_id','','', before the user_cols argument.
  • Upgrade your filtered events table
    • If you use the master filtered events table, you will need to add a new column for the latest version to work. If you have not processed much data yet it may be easier to simply re-run the package from scratch using dbt run --full-refresh --vars 'snowplow__allow_refresh: true', alternatively run the following in your warehouse, replacing the schema/dataset/warehouse and table name for your table:
      ALTER TABLE {schema}.{table} ADD COLUMN unique_id STRING;
      UPDATE {schema}.{table} SET unique_id = event_id||'-'||event_table_name WHERE 1 = 1;
Was this page helpful?