New in BigQuery: Time Unit Partitioning
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 → https://goo.gle/33TPNgV
Видео New in BigQuery: Time Unit Partitioning канала Google Cloud Tech
Google Cloud Blog on BigQuery → https://goo.gle/33TPNgV
Видео New in BigQuery: Time Unit Partitioning канала Google Cloud Tech
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Cloud Run Principle of Least PrivilegeDeveloping on PostgreSQL for Cloud SpannerBuilding a foundation for migration (Part 2)How MLB analyzes data with Google CloudBuild a pet tracking camera appStarting your career in cloud from ITIntroduction to Datastream for BigQueryWhat are the core principles behind Google data centers?Solving for Accessible Phone Calls | Built by Student DevelopersMedical natural language processingIntroduction to GKE cluster modesUse case: getting started with Google CloudIntroduction to image generationWhat is Automatic DLP?How can you embed Looker?How to get a job in cloud without a degreeHow to deploy Cloud Run services with GitHub ActionsHow to earn Google Cloud skill badgesGetting started with Cloud Armor Adaptive ProtectionBigLake in a minuteHow are data centers powered sustainably?