New in BigQuery: Time Unit Partitioning

Опубликовано 13 октября 2020, 16:00

New in BigQuery: more granular control over your partitions with Time Unit Partitioning. Using flexible units of time (ranging from an hour to a year), you can organize time-based data to optimize how your users load and query data. With these updates, BigQuery now supports different time units on TIMESTAMP and DATETIME data types, giving you the flexibility to write extremely fast and efficient queries. As with other partitioning schemes in BigQuery, you can use clustering along with these new partitioning schemes to speed up the performance of your queries. Best part - Time Unit Partitioning is easily implemented using standard SQL DDL, and there is no additional cost for the use of these new partitioning schemes. These new partitioning schemes can help you lower query costs and allow you to match partitioning schemes available in traditional data warehouses for ease of migration. Check out the demo video to see Time Unit Partitioning in action.

Google Cloud Blog on BigQuery → goo.gle/33TPNgV