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

web/v1 explicit SORTKEY encodings changed to RAW #130

Closed mark-walle closed 2 years ago

mark-walle commented 2 years ago

To remove risk of sortkey skew leading to excessive block I/O with early materialization per https://github.com/awslabs/amazon-redshift-utils/blob/master/src/Investigations/EarlyMaterialization.md

issue: #129

colmsnowplow commented 2 years ago

Cherry-picked into release branch, PR is here: https://github.com/snowplow/data-models/pull/132

@mark-walle thanks again for the PR! The UK team is back on Monday and I'd hope we can get a fairly speedy review once they're back. :)