SUPPORT.TWILIO.COM END OF LIFE NOTICE: This site, support.twilio.com, is scheduled to go End of Life on February 27, 2024. All Twilio Support content has been migrated to help.twilio.com, where you can continue to find helpful Support articles, API docs, and Twilio blog content, and escalate your issues to our Support team. We encourage you to update your bookmarks and begin using the new site today for all your Twilio Support needs.

How does deduplication work in views for objects and events in Segment BigQuery warehouse?

Question

How does deduplication work in views for objects and events in Segment BigQuery warehouse?

Product

Twilio Segment

Environment

Segment Console

Answer

Segment handles deduplication differently between object and event _views in BigQuery warehouse :

Object Views: Deduplicated continuously across the entire dataset without any time constraint, ensuring object records always reflect their latest state.
Event Views: Deduplicated using a rolling 60-day window based on event timestamps.

Additional Information

Read more about BigQuery views here.

Have more questions? Submit a request

Powered by Zendesk