Supported Table Structures
We believe there needs to be a clarity on what structures of tables you can actually push to BigQuery. This article shows several examples of tables which would successfully be …
Exception: Service Spreadsheets Failed While Accessing Document
If you are getting a message like this: Exception: Service Spreadsheets failed while accessing document with id {some id}, the problem is likely the sheer size of your spreadsheet. During the …
Data Types: All Columns as STRING
If your data is messy (=multiple data types appearing within 1 column) and you want to make sure that everything will be successfully uploaded to BigQuery, you should use “All …
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 …
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 …