How to export more than 16000 rows in bigquery table to local machine as CSV file?

Question

I want to export output of my select statement in Bigquery. There is "Save Results" option available but it has limit of 16,000 rows.

How can i export more than that?

Answer 1

If your data has more than 16,000 rows you'd need to save the result of your query as a BigQuery Table.

Afterwards, export the data from the table into Google Cloud Storage using any of the available options (such as the Cloud Console, API, bq or client libraries).

Finally, you can use any of the available methods in Google Cloud Storage (Cloud Console, API, gsutil or client libraries) to download the CSV file within your local environment.

Since for the time being you can't export data from a Table directly to a local file.