Reconciling Snowplow and Google Analytics session numbers

In that case, use the collector_tstamp to limit scans on the actual events table (and manage any incremental logic), and define whichever tstamp you like as the partition key of your new table. :slight_smile:

1 Like