title: Download Big Query Table as JSON
body: <p>I would like to download an existing Big Query table as JSON for manipulating the one of column which has long string.</p>
  
  <p>Big Query table has been ingested with Datastore backup file from App Engine to GCS. I used Big Query to read Datastore backup file from GCS and created a table out of it, which has resulted a repeated string column as very long string.</p>
  
  <p>I couldn't parse the long string, so that I would need to download the table as JSON and re up to Big Query as new table. I would need an advice for this approach</p>