Bigquery support preview data instead of select * limit 10

Currently, to see some sample data from a BigQuery table, we have to do a select * limit 10
This is an antipattern as documented in BigQuery

  • select * must be avoided
  • limit ... has no effect on the costs. The entire table is still scanned.

In order to use Redash, the preview feature is really necessary. Is there support for it today?

Unless the preview feature is available via the query language, it’s currently impossible to use in Redash :frowning:

The BigQuery query runner uses the http API, which has a tabledata.list option (more detail here). Any chance we could support this if the query included some key at the top?