issues
search
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
issues
Newest
Newest
Most commented
Recently updated
Oldest
Least commented
Least recently updated
Update README.md
#144
rlh1994
closed
1 year ago
0
Release/web/bigquery/1.0.4
#143
agnessnowplow
closed
1 year ago
0
Release/web/snowflake/1.0.2
#142
agnessnowplow
closed
2 years ago
0
Snowflake Web: Optimise partition pruning (Close #140)
#141
agnessnowplow
closed
2 years ago
2
Snowflake Web: Optimise partition pruning
#140
agnessnowplow
closed
2 years ago
5
Update dbt section within readme
#139
agnessnowplow
closed
1 year ago
0
Release/web/redshift/1.3.1
#138
agnessnowplow
closed
2 years ago
0
Redshift Web: load_tstamp missing from table definition (Close #135)
#137
agnessnowplow
closed
2 years ago
2
Redshift Mobile: load_tstamp missing from table definition
#136
agnessnowplow
closed
2 years ago
0
Redshift Web: load_tstamp missing from table definition
#135
agnessnowplow
closed
2 years ago
0
Maintenance/add migrations
#134
colmsnowplow
closed
2 years ago
0
Add migrations for previous releases
#133
colmsnowplow
closed
2 years ago
0
Release/web/redshift/1.3.0
#132
colmsnowplow
closed
2 years ago
2
Redshift Web: Fix column lengths in manifest tables
#131
colmsnowplow
closed
2 years ago
0
web/v1 explicit SORTKEY encodings changed to RAW
#130
mark-walle
closed
2 years ago
1
Redshift web: Change SORTKEY encoding to RAW
#129
mark-walle
closed
2 years ago
0
All models, base module: Fail with a warning when there's no data
#128
colmsnowplow
opened
2 years ago
0
Update Readme
#127
colmsnowplow
closed
1 year ago
1
Release/web/snowflake/1.0.1
#126
agnessnowplow
closed
2 years ago
0
Snowflake web: Update column check stored procedure
#125
agnessnowplow
closed
2 years ago
0
Snowflake Web: Update copyright notices
#124
agnessnowplow
closed
2 years ago
0
Snowflake web: Remove start_date variable from users module
#123
agnessnowplow
closed
2 years ago
0
Snowflake web: Fix varchar length for pseudonymized fields
#122
agnessnowplow
closed
2 years ago
0
All Redshift and Snowflake models: Fix varchar length for pseudonymized fields
#121
agnessnowplow
opened
2 years ago
0
Snowflake web: Fix logic in users_sessions_this_run to account for sparse data
#120
agnessnowplow
closed
2 years ago
0
replace-events-staged-ddl-logic
#119
aidanradford
closed
2 years ago
4
All models: Fix logic in users_sessions_this_run to account for sparse data
#118
emielver
opened
2 years ago
1
Add backfill functionality
#117
bill-warner
opened
2 years ago
3
Rename Snowplow Insights to Snowplow BDP (close #115)
#116
paulboocock
closed
3 years ago
1
Rename Snowplow Insights to Snowplow BDP
#115
paulboocock
closed
3 years ago
0
Add stored procedures to more automatically generate custom event-level tables
#114
jensnowplow
closed
3 years ago
3
Introduce start_tstamp in events_this_run / events_staged
#113
awoehrl
closed
2 years ago
2
Redshift webmodel custom 02-page-views-join-staged.sql table DDL uses CHAR instead of VARCHAR
#112
aidanradford
opened
3 years ago
2
scratch.events_staged definition is static, scratch.events_this_run mutates with atomic.events
#111
aidanradford
closed
2 years ago
3
Snowflake: no settings for choosing the role of user
#110
sphinks
opened
3 years ago
0
Snowflake web: Fix se_label column length in events_staged
#109
adatzer
closed
2 years ago
1
Update README to reflect dbt support (Close #107)
#108
bill-warner
closed
3 years ago
0
Update README to reflect dbt support
#107
bill-warner
closed
3 years ago
0
Break Ties when joining on timestamps
#106
colmsnowplow
opened
3 years ago
2
Release/mobile/snowflake/1.1.0
#105
bill-warner
closed
3 years ago
0
Snowflake Mobile: Update update_manifest to throw error message
#104
bill-warner
closed
3 years ago
0
Snowflake Mobile: Update commit_table procedure to throw error messages
#103
bill-warner
closed
3 years ago
0
Snowflake Mobile: Fix column order in events_this_run to allow for events_staged table migration
#102
bill-warner
closed
3 years ago
0
Release/mobile/bigquery/1.1.0
#101
bill-warner
closed
3 years ago
0
BigQuery Mobile: Add mobile_staging_reconcilition to temp tables validation config
#100
bill-warner
closed
3 years ago
0
BigQuery Mobile: Fix column order in events_this_run to allow for events_staged table migration
#99
bill-warner
closed
3 years ago
2
Feature/web/bigquery/integration tests
#98
bill-warner
closed
3 years ago
0
Snowflake web: Fix varchar length for yauaa columns
#97
adatzer
closed
2 years ago
0
All models: Make sessions_to_include step in base module deterministic
#96
bill-warner
opened
3 years ago
1
Create generic base module
#95
bill-warner
opened
3 years ago
0
Next