Loading Data into Google BigQuery

Difficulty: Intermediate
Duration: 1 minute and 42 seconds
Students: 219
Rating: 5/5

Google BigQuery is a powerful cloud-based data warehouse that enables you to store and analyze vast amounts of data quickly and cost-effectively. This lesson will equip you with the knowledge and skills needed to master the data import process, understand the tradeoffs involved, and efficiently clean up your imported data. 

Learning Objectives

  • Import records into BigQuery using:
    • Load Jobs
    • Structured Query Language (SQL)
    • Data Transfer Service
    • Storage Write API
  • Clean up your imported records using Data Manipulation Language (DML)

Intended Audience

  • Data Engineers
  • Data Analysts
  • Data Scientists
  • Anyone preparing for a Google Cloud certification

Prerequisites

  • Familiar with BigQuery
  • Comfortable with SQL syntax
  • Access to a GCP account