Hi everyone, I am trying to connect GA as a source...
# ask-community-for-troubleshootingj
João Alves
06/23/2022, 10:00 PMHi everyone, I am trying to connect GA as a source, but I don`t know wich column should be the primary key of each table, does anyone knows it?
m
Marcos Marx (Airbyte)
06/23/2022, 10:09 PMThat’s up to you 😉 My recommendation is: use a close start_date. Sync all stream as full refresh and understand the output from the data you want. After you’l be able to select the primary you want for the streams.
v
Vijay
06/24/2022, 10:33 AM Copy code
view_id, ga_date: should do itVijay
06/24/2022, 10:34 AMYou have to understand the schema of each service.. there is no short cut. If you don't then you will have your data overwritten.
2 Views