Airbyte is an open-source data integration engine that helps you consolidate your data in your data warehouses, lakes and databases.

Airbyte

Hi All, I am working with Google Analytics data and I was wondering, is it possible to extract multiple view's data with one connector?

I created two connections for two different GA views. Connected both sources to same destination and same tables because I want to gather these two views's data in same tables. I set the Sync modes as Incremental Append. My question is, are these two connections will be able to refresh the data correctly when they are scheduled? Because as I understand, incremental append works with ga_date column and if one of the connections appends new records, will the other connection see the other view's record at the current date and think the data is up the date for it's view as well?

Hi <@U02DHRHSYQ6>,
&gt; are these two connections will be able to refresh the data correctly when they are scheduled? Because as I understand, incremental append works with ga_date column and if one of the connections appends new records, will the other connection see the other view's record at the current date and think the data is up the date for it's view as well?
The cursor (ga_date) is stored in the connection state, so this state is not shared between your connection and you can consider they are independent. Are you using normalization on these two connection?
I'm curious to know if your "two sources, same destination table" use case work. Do you mind opening a topic on our new <https://discuss.airbyte.io/|forum> if you want to follow up with our team on the topic? I think this question is really interesting and could help others.