There are several cool features in BigQuery that we can use via standard SQL syntax, often unknown to even the most frequent users. This document intends to show some of them, not being an exhaustive work.
There is no logical order for the topics to follow, just a collection of a few features/functions that I find interesting.
- You will need to have a Google Cloud account. If not, you can create it from here. Click on Get Started for Free button which appears on the top right corner.
- For some examples, you will need to have a Bigquery project (see documentation) and permissions to edit tables and access data.
- Removing Duplicate Data
- Search for a String in a Column or an Entire Table
- Returns the Last Day from a Date Expression
- Secure Through SQL
- Renaming Table
- Access Historical Data
- Scripts and Stored Procedures
- Multi-Statement Transactions
- Dynamic SQL
- Generate a Row ID Based on Column Values
- Debugging Statements
- Create External Table
- Export Data
- Create and Execute ML Models
- Analyze and Visualize Geospatial Data
- Evaluate Arithmetic Expressions