Snowflake Web Model 1.0.1 released

Announcements New releases
1

We are very happy to announce the release of the Snowflake Web Model v1.0.1

This is a patch release that fixes the following:

  • Update column check stored procedure ( #125)
  • Fix varchar length for pseudonymized fields (#122)
  • Remove start_date variable from users module (#123)
  • Update copyright notices ( #124)
  • Fix logic in users_sessions_this_run to account for sparse data (#120)
  • Fix varchar length for yauaa columns (#97)
  • Fix se_label column length in events_staged (#109)

Upgrade Notes

Please note that pre-existing users of the package will have to relax the following columns manually in order for the changes to take effect:

alter table if exists {{.output_schema}}.base_session_id_manifest{{.entropy}}
 alter column session_id set data type varchar(128);
 
alter table if exists {{.output_schema}}.users_manifest{{.entropy}}
 alter column domain_userid set data type varchar(128);
 
alter table if exists {{.scratch_schema}}.events_staged{{.entropy}}
 alter column se_label set data type varchar(4096);
 
alter table if exists {{.output_schema}}.page_views{{.entropy}}
 alter column agent_name set data type varchar,
  agent_name_version set data type varchar,
  agent_name_version_major set data type varchar,
  agent_version set data type varchar,
  agent_version_major set data type varchar,
  device_brand set data type varchar,
  device_name set data type varchar,
  device_version set data type varchar,
  layout_engine_name set data type varchar,
  layout_engine_name_version set data type varchar,
  layout_engine_name_version_major set data type varchar,
  layout_engine_version set data type varchar,
  layout_engine_version_major set data type varchar,
  operating_system_name set data type varchar,
  operating_system_name_version set data type varchar,
  operating_system_version set data type varchar;

alter table if exists {{.scratch_schema}}.page_views_staged{{.entropy}}
 alter column agent_name set data type varchar,
  agent_name_version set data type varchar,
  agent_name_version_major set data type varchar,
  agent_version set data type varchar,
  agent_version_major set data type varchar,
  device_brand set data type varchar,
  device_name set data type varchar,
  device_version set data type varchar,
  layout_engine_name set data type varchar,
  layout_engine_name_version set data type varchar,
  layout_engine_name_version_major set data type varchar,
  layout_engine_version set data type varchar,
  layout_engine_version_major set data type varchar,
  operating_system_name set data type varchar,
  operating_system_name_version set data type varchar,
  operating_system_version set data type varchar;
 
alter table if exists {{.output_schema}}.sessions{{.entropy}}
 alter column agent_name set data type varchar,
  agent_name_version set data type varchar,
  agent_name_version_major set data type varchar,
  agent_version set data type varchar,
  agent_version_major set data type varchar,
  device_brand set data type varchar,
  device_name set data type varchar,
  device_version set data type varchar,
  layout_engine_name set data type varchar,
  layout_engine_name_version set data type varchar,
  layout_engine_name_version_major set data type varchar,
  layout_engine_version set data type varchar,
  layout_engine_version_major set data type varchar,
  operating_system_name set data type varchar,
  operating_system_name_version set data type varchar,
  operating_system_version set data type varchar;
5 Likes