BigQuery-Python icon indicating copy to clipboard operation
BigQuery-Python copied to clipboard

bigquery.errors.JobInsertException: Reason:invalid. Message:Table wasel-95b26:com_mysada_news_ANDROID.app_events_20170611 cannot be exported as CSV because it has a nested schema.

Open NasserGo-zz opened this issue 8 years ago • 1 comments

bigquery.errors.JobInsertException: Reason:invalid. Message:Table wasel-95b26:com_mysada_news_ANDROID.app_events_20170611 cannot be exported as CSV because it has a nested schema.

wx20170613-133507

I want to export data with json format

NasserGo-zz avatar Jun 13 '17 05:06 NasserGo-zz

you can try this

job = bigquery_client.extract_table_to_storage(job_name, table, destination) job.destination_format ='CSV' job.print_header = True job.begin()

job, object has the format type. Ref: https://cloud.google.com/bigquery/docs/exporting-data#bigquery-export-table-gcs-python

vrcs avatar Jun 13 '17 06:06 vrcs