Solution: BigQuery SQL

Solution

Let's check the solution to this challenge. Keep in mind that there isn't only one solution to this problem. We will go through a few alternatives.

Create source tables

Here is the standard way of using DDL to create tables in BigQuery. We can also create a table using many other programming languages, such as Python, Java, Ruby, etc. Read BigQuery documentation for more information.