-
Notifications
You must be signed in to change notification settings - Fork 16
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Use derived_tstamp as the primary tstamp in Redshift #420
Comments
This impacts the table |
I noticed sql-runner appears to still be using collector_tstamp instead of derived_tstamp as well, so you guys may want to update that when you get to this issue |
We need to test whether this leads to tables that are more unsorted after inserting new events. |
It'd be interesting to explore the impact of this patch: https://forums.aws.amazon.com/ann.jspa?annID=4157
This should eliminate the need to vacuum if we continue to use the collector timestamp, and reduce (but not eliminate) this need if we were to switch to the derived timestamp. |
Likely this is no longer a good idea, but moving over to review |
Currently we use the collector_tstamp for the root_tstamp value.
It would be preferable to use the derived_tstamp once all our client side trackers support generating a dvce_sent_tstamp. (Because that point from an analytics perspective you're only interested in the
derived_tstamp
.We need to figure out how we migrate from
collector_tstamp
->derived_tstamp
e.g. what happens for old users who have events withoutderived_tstamp
values.The text was updated successfully, but these errors were encountered: