Why this topic?
The first time I encountered Google BigQuery in 2016, I was thrown off by some of its unique syntax. Previously, I had used mainly Hive and Teradata. Therefore, I’d like to share the most unfamiliar aspects to help those of you making this transition too.
What it covers:
I walk through the most daunting aspects of Google BigQuery:
- The need for back ticks
- Different syntax on date functions
- Date conventions