Google Analytics, Dataform, Bigquery, Google Cloud Platform, Sql.
in BigQuery which is by no means impossible, but it ain’t no fun either. By using either of the strategies from Taneli’s article and utilizing Dataform’s out-of-the-box solution, you don’t have to construct a query like this (which is what runs under the hood): This is what Dataform runs under the