I’m trying to model some data from the warehouse sync files (in BigQuery) and I’m facing some issues with duplicate rows when I join Deliveries and Metrics.
What’s the correct way to join these two tables - I’m using delivery_id which is resulting in a few duplicates, but event_id doesn’t seem to be the correct field as it returned incomplete data.
Best answer by Maddie
View original