CODEWITHSUNDEEP
google-bigquery
user1932483
user1932483

Reputation: 75

Google Bigquery Command Line Return Limit

I just upgraded the bigquery command line program, and there is now a limit to the rows being returned when I run queries. The limit seems to be 100 rows. Before upgrading, I was able to return thousands of rows. I'm using Debian. Is there a way to expand the limit of rows returned? Let me know if I can provide any more information.

Upvotes: 4

Views: 2627

Answers (1)

Jordan Tigani
Jordan Tigani

Reputation: 26637

Try the --max_rows flag. See the output of bq help query:

USAGE: bq.py [--global_flags] <command> [--command_flags] [args]
    query      Execute a query.
... 
  --max_rows: How many rows to return in the result.
    (default: '100')
    (an integer)

Upvotes: 8

Related Questions