Schema Change Log
September 20, 2023
This afternoon, we were able to seamlessly roll out a vastly smaller/faster/cheaper version of your
added_people view. It has gone from something like 320GB to 83 MB for a typical client. That’s about 3900x smaller! So hopefully your syncs today took another major step forward.
September 19, 2023
Today, we have introduced new versions of all your views except `added_people` and `person_tag_associations` to make them smaller, faster, and cheaper to query. For views that used to be massive, you will see the biggest differences. For example, a query of the `actions` view used to process about 160GB. Now it will process about 233 MB. That is about 700x smaller! Similarly, a query to `responses` used to process 160GB and now processes about 1GB.
We have now replaced almost all of your views with the new cheaper versions seamlessly in the background. The only action you have to take is increasing the frequency at which you query them!
August 31, 2023
- The new Content Sharing tables were using the wrong datatype for their user id columns. So the following fields changed from INTEGER to STRING:
August 29, 2023
- Added tables to support many new upcoming features around content sharing:
- New columns on existing tables
Possible new value of
share_content in the
Interaction Type column of the
Action Card Interactions export.
August 11, 2023
- Added table:
user_deviceswith the following columns:
- Added table
push_notification_actionswith the following columns:
July 20, 2023
- Added field:
June 12, 2023
- Three new columns in the Action Card Interactions export:
- Upload URL
- Upload Type