Creating Date-Partitioned Tables in BigQuery
Offered By: Google via Google Cloud Skills Boost
Course Description
Overview
This lab focuses on how to query partitioned datasets and how to create your own dataset partitions to improve query performance, which reduces cost.
Syllabus
- GSP414
- Overview
- Setup and requirements
- Task 1. Create a new dataset
- Task 2. Creating tables with date partitions
- Task 3. View data processed with a partitioned table
- Task 4. Creating an auto-expiring partitioned table
- Task 5. Your turn: create a partitioned table
- Task 6. Confirm the oldest partition_age is at or below 60 days
- Congratulations!
Tags
Related Courses
Supply Chain FundamentalsMassachusetts Institute of Technology via edX The Digital Economy: Effective Supply Chain Management
The Open University via FutureLearn Prototipazione virtuale
University of Naples Federico II via Federica Advanced Manufacturing Process Analysis
University at Buffalo via Coursera Improving Your Business Through a Culture of Health
Harvard University via edX