Can someone clarify a point regarding Incremental Deduped History User-Defined Primary key. In our case, we're pulling Google Analytics data with these columns: Dimensions: Date, Campaign, Source & Medium, Event Category, Metrics: Total Events, Event Value How do I select User-Defined Primary key. My guess is that GA won't return duplicated records of the combination of Date, Campaign, Source & Medium, Event Categor, so using all of them as the composite primary key should work. Am I correct in approaching it this way?

Hey Jonas it's possible to get duplicate records if some lookback(For every sync we actually pull for last

x

days) is set. So then you have to add in date also. I hope this helps

@Harshith (Airbyte) I have included Date in the above composite primary key: Date, Campaign, Source & Medium, Event Category, Is there another Date you're referring to?

Oops my bad. Yeah that should be good 👍

Just wanted to say thank you for this. It was very helpful in getting my connector set up 👍