Limited results when using Excel BigQuery connector

I've pulled a data extract from BigQuery using the Excel connector but my results have been limited to 230,000 records.

Is this a limitation of the connector or something I have not done properly?

Answers


BigQuery does have a maximum response size of 64MB (compressed). So, depending on the size of your rows, it's quite possible that 230,000 is the maximum size response BigQuery can return.

See more info on quotas here: https://developers.google.com/bigquery/docs/quota-policy

What's the use case -- and how many rows are you expecting to be returned? Generally BigQuery is used for large aggregate analysis, rather than results which return tons of unaggregated results. You can dump the entire table as a CSV into Google Cloud Storage if you're looking for your raw dataset too.

Also, you may want to try running the query in the UI at: https://bigquery.cloud.google.com/


Need Your Help

Spring webservices how to pass file bytes

web-services spring spring-mvc

I am trying to write a spring webservices which will be used to pass a file as byte[] value. Is this possible using webservice? Can anybody show an example in any website? I have searched a lot and i

ConcurrentModificationException when updating JavaFX Tree in the background

java javafx-2

My code creates TreeItem<String> in a background task since I have a lot of them and their creation takes a considerable amount of time in which the application freezes. In this example it d...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.