We're excited to announce an update in Event-based Streaming! Starting November 1, 2023, 'events_intraday_YYYYMMDD' tables are now automatically created with clustering based on the event_name field. Understanding clustered tables is key to maximizing performance and cost efficiency. The real benefits kick in when queries exclusively use clustered tables, allowing you to increase cost savings during data processing.
Clustered tables in BigQuery
Clustered tables in BigQuery are tables that have a user-defined column sort order using clustered columns. In BigQuery, a clustered column is a user-defined table property that sorts storage blocks based on the values in the clustered columns. Check out the official documentation for a deeper dive.
Impact on existing 'events_intraday_YYYYMMDD' tables and Transformation templates
The 'events_intraday_YYYYMMDD' tables created before November 1, 2023, remain unaffected, and the new clustering doesn't disrupt Transformation templates. No code adjustments are needed – it's a seamless transition.
If you have any questions, feel free to reach out to us at bi@owox.com or visit our FAQ article on clustered tables in Event-based Streaming.
At OWOX BI, we are committed to delivering products that empower you with accurate and actionable insights. Thank you for choosing OWOX BI. Stay tuned for more updates!
0 Comments