Queries for GoogleSpreadsheet


#1

Redash is great! Thank you very much for this great app.

Im working with BigQuery and MySql and all is ok. But how can I use GS?

  • Documentation says I must use something like “uid|gid” format, but it forks only for the first tab (gid=0) . Also, how can I query some range? For example, query B2:E5.
  • How to set headers manually? Currently it uses first row for it
  • There is also a bug(?), when my table contains numeric value in first row, redash ignores texts. Maybe it is autoformatting?

#2

@biakaveron sorry for the late response…

Documentation says I must use something like “uid|gid” format, but it forks only for the first tab (gid=0) . Also, how can I query some range? For example, query B2:E5.

Current implementation lets you bring in a whole sheet only. No support for ranges or other type of querying on top of the data. I do want to introduce a way to run custom queries on top of the spreadsheet data, but no ETA for this.

How to set headers manually? Currently it uses first row for it

Yep, that’s another limitation.

There is also a bug(?), when my table contains numeric value in first row, redash ignores texts. Maybe it is autoformatting?

It guesses the type of the column based on the first row… I guess this can be improved.


#3

A new way to query spreadsheets within re:dash:

Pass the spreadsheets through BigQuery :slight_smile:

https://cloud.google.com/bigquery/federated-data-sources