Data Types: Manual
If you want to retain control over data types for each column in your table, you can use Manual option in the Data Types dropdown. The down side is that …
Data Types: Autodetect
If you are lazy person like us, you will likely want to use Autodetect option for detecting the data types: This is a very helpful option when your table has …
How to Set Datetime Column to YYYY-MM-DD HH:MM:SS Format?
If your table has a datetime column and you are using either Manual or Autodetect option for upload, it’s important to make sure your column is formatted properly because BigQuery …
I Only See Help Button
On rare occasions, it may happen, that you only see “Help” button in the add-on menu and no other items: How to get around it? Unfortunately, you have to uninstall …
How to Enable BigQuery API in Google Cloud Platform Project?
Before you can upload anything from Google Sheets to BigQuery with our BigQuery uploader for Google Sheets, you need to enable BigQuery API in your Google Cloud Platform (aka “GCP”) …
How to Set Date to YYYY-MM-DD Format in Google Sheets?
You may run into issues with your date column during uploads: Uploads failing because of incorrect formatting of your date column – this applies mainly to Manual option under Data …
BigQuery Uploader for Google Sheets: Release Notes
2020-10-19: Version 2.1 Released 2 updates: 1) We’ve added an option to enable email notifications in case your scheduled upload fails: Please make sure to always “Save Schedule” when you …
How to Upload Multiple Sheets from Google Sheets to Big Query?
One would think that uploading multiple sheets from a Google spreadsheet to BigQuery would be natively supported since both products come from Google, right? Too bad! BigQuery only supports uploading …
Download Our FREE Google BigQuery Uploader for Google Sheets Add-On!
The Problem So what’s the problem? You may have been playing with Google BigQuery and you may have noticed that you can use an already existing Google Sheet as data …
Differences between Excel, Power BI, Power Query, and Query Editor
When it comes to Microsoft’s business intelligence products, understanding the basic terms can be complicated – especially if you are just diving into data & analytics. So let’s answer the …