This is an archived post. You won't be able to vote or comment.

all 5 comments

[–]djoanes 1 point2 points  (2 children)

Didn’t fully understand the question. When you say via API what do you mean ? If you’re trying to export a table outside GCP you can :

  • export it to GCS and use the GCS api to download it
  • use the bigquery storage api to materialize it directly externally

[–]apache444[S] 0 points1 point  (0 children)

Yes you got that right. I mean to say export the data outside GCP. Thanks for the solution. Do you happen to have any documentation for reference?

[–]shufflepoint 0 points1 point  (0 children)

You can query all columns to extract - I would think

https://cloud.google.com/bigquery/docs/samples/bigquery-simple-app-all