...

There are two scenarios that you want to use a view for:

1. Flatten down the complex data into a simpler form for the purposes of reporting on in tools like Google Data Studio of Power BI.

2. Adding additional calculations into the base table for further analysis.

What 3rd Party Tools Are Merchants Using with BigQuery

These are some of the tools that we know merchants are using with BigQuery:

• Google Data Studio - reporting

• Microsoft Power BI - reporting

• DBT - modeling

• Make.com - ETL/integration

• Hightouch - ETL/integration

• Funnel - bring data into BigQuery

• Looker - reporting

We find that almost all tools in the data warehouse / CDP / reporting space will talk to BigQuery.

Sample Queries

Important Note: If you’re going to write SQL queries with the nested data that is in the BigQuery tables, you’ll want to learn CROSS JOIN UNNEST and other array operations documented in the BigQuery documentation.

...