Velir / dbt-ga4

dbt Package for modeling raw data exported by Google Analytics 4. BigQuery support, only.
MIT License
312 stars 134 forks source link

multi-site support for streaming frequency #187

Closed dgitis closed 1 year ago

dgitis commented 1 year ago

Description & motivation

This PR adds streaming support for multi-property installations.

I could have unified the events_ and events_intraday_ code in the combine_property_data macro a little more writing both to events_* tables because, as things are currently written, daily and streaming frequencies are mutually exclusive and saved a couple lines of code. However, it is likely that supporting the daily+streaming frequency will require separation of code and it is easier to debug when they write to events_ and events_intraday_ code.

Checklist

adamribaudo-velir commented 1 year ago

Look good. I didn't think it would be that easy. I guess daily+streaming would be hard because you'd have to juggle the fact that the streaming data is eventually merged into the daily data.