Did you know that Google Analytics 4 now exports event data at the individual user level for free? In this episode of SnowFlake Bytes, Felipe Hoffa, Snowflake’s Data Cloud Advocate, shows you how to move this GA4 data into Snowflake and translate the sample queries into Snowflake SQL. His favorite part of the process? Creating a UDF that transforms the original schema nested data into a variant object that is easier to query.

If you have not set up your own Google Analytics account yet, you can still reproduce all the steps and queries shown in this video by using the sample data that Google publishes. Then you can try all this yourself with a Snowflake free trial: https://signup.snowflake.com/.

For more details, check out Felipe's post on Medium at https://medium.com/snowflake/google-analytics-4-in-snowflake-sql-cookbook-d455087882c9.

And be sure to let him know what you think!

❄Join our YouTube community❄ https://bit.ly/3lzfeeB