Current Schemas
You can find our existing BigQuery Mirror Schema here and our existing Scheduled Exports schema here.
Schema Change Log
September 20, 2023
BigQuery Mirror
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.
Scheduled Exports
No changes.
September 19, 2023
BigQuery Mirror
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!
Scheduled Exports
No changes.
August 31, 2023
BigQuery Mirror
- The new Content Sharing tables were using the wrong datatype for their user id columns. So the following fields changed from INTEGER to STRING:
- content_actions.user_id
- content_assets.created_by_user_id
- content_bookmarks.user_id
- content_feedback.created_by_user_id
- content_galleries.created_by_user_id
- content_labels.created_by_user_id
- content_shared_galleries.created_by_user_id
Scheduled Exports
No changes.
August 29, 2023
BigQuery Mirror
- Added tables to support many new upcoming features around content sharing:
- content_actions
- content_assets
- content_bookmarks
- content_feedback
- content_galleries
- content_label_associations
- content_labels
- content_shared_galleries
- social_platforms
- New columns on existing tables
- action_cards.content_asset_id
- campaigns.enable_content_library
Scheduled Exports
Possible new value of share_content
in the Interaction Type
column of the Action Card Interactions
export.
August 11, 2023
BigQuery Mirror
- Added table:
user_devices
with the following columns:- id
- user_id
- status
- platform
- notification_permissions
- created_on
- updated_on
- reach_native_version
- locale
- Added table
push_notification_actions
with the following columns:- id
- user_device_id
- push_notification_id
- action_type
- created_on
- updated_on
- campaign_id
- notification_campaign_id
Scheduled Exports
No changes
July 20, 2023
BigQuery Mirror
- Added field:
user_to_campaign_associations.last_seen_on
Scheduled Exports
No changes
June 12, 2023
BigQuery Mirror
No changes
Scheduled Exports
- Three new columns in the Action Card Interactions export:
- Upload URL
- Comment
- Upload Type