November 1, 2023 — OWOX BI Streaming. Unlock cost savings and accelerate queries with clustering in 'events_intraday_YYYYMMDD' tables

Streaming updates.png

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

Screenshot 2023-11-09 at 20.14.32.png

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 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!

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.