Loading Data into Google BigQuery


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


  • Familiar with BigQuery
  • Comfortable with SQL syntax
  • Access to a GCP account
About the Author
Daniel Mease, opens in a new tab
Google Cloud Content Creator
Learning paths

Daniel began his career as a Software Engineer, focusing mostly on web and mobile development. After twenty years of dealing with insufficient training and fragmented documentation, he decided to use his extensive experience to help the next generation of engineers.

Daniel has spent his most recent years designing and running technical classes for both Amazon and Microsoft. Today at Cloud Academy, he is working on building out an extensive Google Cloud training library.

When he isn’t working or tinkering in his home lab, Daniel enjoys BBQing, target shooting, and watching classic movies.

Covered Topics