3 ms·
Mandatory shameless plug - Google Sheets integrates with Google BigQuery. You can: - Query data in Google Sheets from BigQuery - Create virtual views in BigQ
by vgt 9y ago
Mandatory shameless plug - Google Sheets integrates with Google BigQuery.
You can:
- Query data in Google Sheets from BigQuery
- Create virtual views in BigQuery that are powered by Google Sheets
- One-click export data from BigQuery to Google Sheets (< 20k rows or so)
- Using AppScript, build dashboards and reports in Sheets that query BigQuery for results.
(work at G)
- dagss 9y agoI tried to rely on your first bullet point and randomly end up with BigQuery surpassing some API treshold towards Drive (paying customer). Have to carefully manage doing copy-queries over to BQ, which is a pain, but better than nothing I guess.
- vgt 9y agoThanks for the feedback! I'd love to get more detail on your experiences so that we can iterate and improve and would be eternally thankful if you emailed me.