É possível exportar os resultados da consulta para um arquivo local (como CSV ou JSON),
o Google Drive ou as Planilhas Google. Para mais informações, consulte
Exportar resultados de consulta para um arquivo.
Exportar tabelas
É possível exportar suas tabelas do BigQuery nos seguintes formatos de dados:
É possível fazer o download de recursos de código do BigQuery Studio,
como consultas salvas ou notebooks,
para manter uma cópia local dos seus recursos. Para mais informações sobre como fazer o download dos seus recursos de código do BigQuery, consulte:
É possível configurar fluxos de trabalho de ETL reverso (RETL, na sigla em inglês) (pré-lançamento) para mover dados do
BigQuery para os seguintes bancos de dados:
[[["Fácil de entender","easyToUnderstand","thumb-up"],["Meu problema foi resolvido","solvedMyProblem","thumb-up"],["Outro","otherUp","thumb-up"]],[["Difícil de entender","hardToUnderstand","thumb-down"],["Informações incorretas ou exemplo de código","incorrectInformationOrSampleCode","thumb-down"],["Não contém as informações/amostras de que eu preciso","missingTheInformationSamplesINeed","thumb-down"],["Problema na tradução","translationIssue","thumb-down"],["Outro","otherDown","thumb-down"]],["Última atualização 2025-09-04 UTC."],[[["\u003cp\u003eBigQuery allows you to export data in various ways, including exporting query results to local files, Google Drive, or Google Sheets.\u003c/p\u003e\n"],["\u003cp\u003eYou can export BigQuery tables to Cloud Storage in CSV, JSON, Avro, or Parquet formats, each supporting different compression types.\u003c/p\u003e\n"],["\u003cp\u003eBigQuery tables can also be exported as Protobuf columns for nested data structures or when wider language support is required.\u003c/p\u003e\n"],["\u003cp\u003eBigQuery Studio code assets, such as saved queries and notebooks, can be downloaded to maintain local copies.\u003c/p\u003e\n"],["\u003cp\u003eReverse ETL (RETL) workflows can move data from BigQuery to databases like Bigtable, Spanner, and Pub/Sub.\u003c/p\u003e\n"]]],[],null,["# Introduction to data export\n===========================\n\nThis document describes the different ways of exporting data from\nBigQuery.\n\nFor more information about data integrations, see\n[Introduction to loading, transforming, and exporting data](/bigquery/docs/load-transform-export-intro).\n\nExport query results\n--------------------\n\nYou can export query results to a local file (either as a CSV or JSON file),\nGoogle Drive, or Google Sheets. For more information, see\n[Export query results to a file](/bigquery/docs/export-file).\n\nExport tables\n-------------\n\nYou can export your BigQuery tables in the following data formats:\n\nYou can also [export your BigQuery tables as Protobuf columns](/bigquery/docs/protobuf-export)\nwhen working with nested data structures that require object\ntype safety, or if you need a wider language support.\n\nExport BigQuery code assets\n---------------------------\n\nYou can download [BigQuery Studio](/bigquery/docs/query-overview#bigquery-studio)\ncode assets, such as [saved queries](/bigquery/docs/saved-queries-introduction) or [notebooks](/bigquery/docs/notebooks-introduction)\nto maintain a local copy of your assets. For more information on downloading your BigQuery code assets, see the\nfollowing:\n\n- [Download saved queries](/bigquery/docs/manage-saved-queries#download_saved_queries)\n- [Download notebooks](/bigquery/docs/manage-notebooks#download_a_notebook)\n\nExport using reverse ETL\n------------------------\n\nYou can set up reverse ETL (RETL) workflows ([preview](https://cloud.google.com/products#product-launch-stages)) to move data from\nBigQuery to the following databases:\n\n- [Export to Bigtable](/bigquery/docs/export-to-bigtable)\n- [Export to Spanner](/bigquery/docs/export-to-spanner)\n- [Export to Pub/Sub](/bigquery/docs/export-to-pubsub)\n\nWhat's next\n-----------\n\n- Learn about [quotas for export jobs](/bigquery/quotas#export_jobs).\n- Learn about [BigQuery storage pricing](/bigquery/pricing#storage)."]]
