Introduction to data export
This document describes the different ways of exporting data from BigQuery.
For more information about data integrations, see Introduction to loading, transforming, and exporting data.
Export query results
You can export query results to a local file (either as a CSV or JSON file), Google Drive, or Google Sheets. For more information, see Export query results to a file.
Export tables
You can export your BigQuery tables in the following data formats:
| Data format | Supported compression types | Supported export methods |
|---|---|---|
| CSV | GZIP | Export to Cloud Storage |
| JSON | GZIP | Export to Cloud Storage Read from BigQuery using Dataflow |
| Avro | DEFLATE, SNAPPY | Export to Cloud Storage Read from BigQuery using Dataflow |
| Parquet | GZIP, SNAPPY, ZSTD | Export to Cloud Storage |
You can also export your BigQuery tables as Protobuf columns when working with nested data structures that require object type safety, or if you need a wider language support.
Export BigQuery code assets
You can download BigQuery Studio code assets, such as saved queries or notebooks to maintain a local copy of your assets. For more information on downloading your BigQuery code assets, see the following:
Export using reverse ETL
You can set up reverse ETL (RETL) workflows (preview) to move data from BigQuery to the following databases:
What's next
- Learn about quotas for export jobs.
- Learn about BigQuery storage pricing.