It seems like the fct_ga4__pages table is creating duplicate rows where it should now and that removing the page_engagement_key fields fixes the problem.
From Tony Tushar on dbt Slack
So if I’m seeing duplicates across all dimension fields in that table, but seeing differences on say a single metric/fact column, is it wrong to group by date further in that table, as you’re confirming it is not by hour anymore.
--- snip ---
Lastly, will mention that seems like the removal of page_engagement_key in the page_engagement CTE for fct_ga4__pages is causing duplicates.
It seems like the
fct_ga4__pages
table is creating duplicate rows where it should now and that removing thepage_engagement_key
fields fixes the problem.From Tony Tushar on dbt Slack
--- snip ---