Anda dapat mengekspor hasil kueri ke file lokal (baik sebagai file CSV atau JSON), Google Drive, atau Google Spreadsheet. Untuk mengetahui informasi selengkapnya, lihat
Mengekspor hasil kueri ke file.
Mengekspor tabel
Anda dapat mengekspor tabel BigQuery dalam format data berikut:
Anda juga dapat mengekspor tabel BigQuery sebagai kolom Protobuf
saat menggunakan struktur data bertingkat yang memerlukan keamanan jenis objek, atau jika Anda memerlukan dukungan bahasa yang lebih luas.
Mengekspor aset kode BigQuery
Anda dapat mendownload aset kode BigQuery Studio, seperti kueri tersimpan atau notebook untuk mempertahankan salinan lokal aset Anda. Untuk informasi selengkapnya tentang cara mendownload aset kode BigQuery, lihat artikel berikut:
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 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)."]]
