In Automation We Trust
It’s also important to realize what happens when different users with different BigQuery rights oversave scheduler within a spreadsheet. Let’s have these 2 users….: Joe has “BigQuery Data Viewer” rights …
This article will show how to run your first query with BigQuery Downloader for Google Sheets. This is our sample data in BigQuery which we will want to download to …
Target Cell When you set up your query definition, you are asked for a “target cell”. It’s the cell in the top left corner of the range where your query …
When you use our BigQuery Downloader for Google Sheets you will eventually notice that query results are being inserted in 1000 row batches. So if your query result is 20k rows, …
There are 2 main limitations: Size of your spreadsheet Max runtime for scripts and add-ons Currently, a spreadsheet can hold max 5 million cells. If a query is about to …
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 …
You can upload around 700,000 cells from one sheet at once. Number of cells = (number of rows) x (number of columns). The exact count also depends on the lengths …
We’ve received a few complaints from paid users saying that the add-on behaves oddly. The typical symptoms are: Scheduler is not loading. Scheduler is not saving new schedule. Menu is …
Scheduled uploads may not always trigger for extremely heavy users. This is not necessarily the fault of the uploader. However, we still believe that 99.9% users should be just fine. …
Sometimes, it’s possible that nothing happens after clicking “Setup Upload Definitions” in the menu: We don’t know why exactly this is happening but we are at least able to replicate …