How to Run Your First Query
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 …
Understanding the Target Cell Configuration
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 …
1000 Row Batch Inserts
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, …
Known Limitations of BigQuery Downloader for Sheets
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 …
BigQuery Downloader for Google Sheets Released!
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 …
BigQuery Uploader for Google Sheets 2.0 Released!
Today is a big day because we are releasing a brand new version of our BigQuery Uploader for Google Sheets. The main improvements are: The long awaiting scheduler is finally …
BigQuery Uploader for Google Sheets 2.0: What’s Changing?
Great news! We are launching the brand new version of our BigQuery Uploader for Google Sheets with the long-awaited scheduler. What’s Changing? The config sheet has no longer any purpose. …
How to Setup Scheduled Uploads
Once you define your upload definitions, you may want to schedule your uploads so you don’t have to upload your tables manually. First of all, you need to enter the …
How to Set United States Locale in Google Sheets
If you are not based in the United States, you should set your spreadsheet to “United States” locale before you run your first upload with BigQuery Uploader for Google Sheets. …
How to Run Your First Upload
Making the first step is always the hardest part of the job. That’s why we have prepared this tutorial to help you out. Follow these 5 easy steps. Step 1: …