Skip to content

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. #134

Open
Open
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.#134

Description

@NasserGo-zz
NasserGo-zz
opened on Jun 13, 2017

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

Activity

  1. vrcs commented on Jun 13, 2017

    @vrcs
    vrcs
    on Jun 13, 2017

    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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions