Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Google

Creating Date-Partitioned Tables in BigQuery

Google via Google Cloud Skills Boost

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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!

Reviews

Start your review of Creating Date-Partitioned Tables in BigQuery

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.