BigQuery Scripting - SQL Magic Spells
Pawel Kapuscinski, Data Analyst, Adswerve
Imagine enhancing SQL with loops. Want more? Let’s go one step further, imagine your query can decide if it should run based on a provided variable. Not enough? How about constructing queries on the fly and executing them using nothing more than the BigQuery UI. Welcome to the magic world of BigQuery scripting.
Insights Manager, Rezdy
So, you need an SQL data model but don't know how to get started? This talk was about Rezdy's journey using DBT over the last 7 months, and the things you may need to consider as you're getting started.
Principal Developer Advocate, Poplin Data
Raw event data like you get from GA360, Adobe Analytics or Snowplow gives you much more information than the aggregated data you see through reports but they can be unwieldy to use. Building an SQL data model allows you to build centralised business rules for things like conversions, traffic sources and rollup events while still being able to change them. When something screws up, you can paper over those changes so your business users only see a perfect timeline. This talk walked through building a data model on top of raw Snowplow data using reasonably simple SQL.