How To Export More Than 16000 Records To A CSV File Using Google BigQuery SQL

Описание: When you try to export a query result in Google BigQuery, the platform only lets you to export the first 16,000 records. If you want to export the entire resultset, there are a couple options: using Google BigQuery API or the EXPORT DATA OPTION feature in Google BigQuery SQL.

In this tutorial, I will walk you through how to use BigQuery EXPORT DATA OPTIONS function in BigQuery SQL and Google Cloud Storage to export the entire resultset to a CSV file.

PS: The EXPORT DATA OPTIONS function can only export up to 1GB of data per file. If your table size is exceeds 1GB, EXPORT DATA OPTIONS will split the table into multiple files.

📑 More information on BigQuery: https://cloud.google.com/bigquery/

► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Paypal: https://www.paypal.me/jiejenn/5
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we'll both get a free stock: https://bit.ly/3iWr7LC

► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
🌳 Becoming a Patreon supporter:   / jiejenn  
🛒 By shopping on Amazon → https://amzn.to/2JkGeMD
📘 Facebook Page →   / madeinpython  
📘 More tutorial videos on my website → https://LearnDataAnalysis.org
👩‍💻 Follow me on Linked:   / jiejenn  
✉️ Business Inquiring: [email protected]

#BigQuery #GoogleBigQuery #GCP #GoogleStorage #GoogleCloud