Issue with Replication Start Date in Universal Analytics to BigQuery Connection

Summary

The user is facing an issue where the replication start date set in Airbyte UI for connecting Universal Analytics with BigQuery is not reflected in the destination, with data starting from a different date. The user suspects it may be related to the Google reporting API limitations on extracting data for the last 14 months.


Question

Hi team, I am having the issue about replication start date when connecting between universal analytics with BigQuery. When I chose the start date at 2020-01-01 on airbyte UI and started extraction process, however, the data in my destination always start at 2022-03-28. I am using ga_date as a cursor field . Have everyone encountered this issue before ? is that issue related to limit of Google reporting API that allow extract data in last 14 months ? Much appreciated for your help !



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["replication-start-date", "universal-analytics", "bigquery", "airbyte-ui", "google-reporting-api", "ga-date", "cursor-field", "data-extraction", "limitation"]