Google Cloud Platform

Try It Free Contact Sales

How-to Guides

Loading data

Loading Data Overview

Load your data into BigQuery from a variety of source formats, including CSV, JSON, and Avro.
Preparing Data for Loading

Prepare your data to get the most out of BigQuery analytics.
Transforming Data

Transform the source data format into a format supported by BigQuery.
Loading Data From Cloud Storage

Load data directly from Google Cloud Storage.
Loading Data From Cloud Datastore

Load data directly from a Cloud Datastore backup that resides on Google Cloud Storage.
Loading Data with a POST Request

Learn about the available loading options when using the BigQuery API.
Loading Data with SQL DML

Load data using SQL DML insert statements.
Streaming Data Into BigQuery

Stream your data into BigQuery one record at a time using the BigQuery API.
Creating and Updating Date-Partitioned Tables

Create and update large tables that are partitioned by date.

Querying Data

Updating Data

Updating Data in BigQuery

Update data in BigQuery tables using SQL DML.

Exporting Data

Exporting Data From BigQuery

Export data from BigQuery to several formats, including CSV, JSON, Avro, and Google Cloud Storage.

BigQuery API Basics

Web UI

BigQuery Web UI

BigQuery exposes a graphical web UI that you can use to load and export data, run queries, and perform other user and management tasks in your browser.

Command-line Tool

bq Command-Line Tool

The bq command-line tool is a python-based tool that accesses BigQuery from the command line.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 3.0 License, and code samples are licensed under the Apache 2.0 License. For details, see our Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Send feedback about...

This page

Documentation feedback

BigQuery

Product feedback