We are releasing our brand new product BigQuery Downloader for Google Sheets so we can also cover getting data from BigQuery to Google Sheets and not only uploading data from Google Sheets to BigQuery.
The product lets you run SQL queries directly from Google Sheets to BigQuery without leaving Google Sheets.
Get the product here:
Features
The most important features are:
- Query manager – you can save your queries directly in the spreadsheet.
- Real time query debugging – your query is being validated in real time as as you type your SQL.
- Scheduler – you can schedule your downloads to run hourly, daily, or weekly.
- Notifications on failures – you can also opt for notifications whenever your queries fail.
- The data is being stored as a standard Google Sheet range which can be referenced throughout your spreadsheet
Licensing
Users first enter a 14 day trial period. No credit card is required. There are on hidden limitations in the product when being on trial. Whenever the trial expires, the product stops working completely.
If you buy a license, you will automatically get license for our uploader product too. There are no extra actions needed for the activation of the uploader, you only need to install it from the marketplace.
If you happen to buy the Uploader first, you will also get a license for the Downloader.
Basically, no matter you product you buy, you will always get 2 licenses – one for downloader, one for uploader.
Limitations
Please see the list of know limitation in our help center here.
Screenshots
