airbytehq / airbyte

The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.
https://airbyte.com
Other
16.32k stars 4.16k forks source link

[source-google-analytics-data-api] GA4 Auth error not visible #35292

Open gordonkjlee opened 9 months ago

gordonkjlee commented 9 months ago

Connector Name

source-google-analytics-data-api

Connector Version

2.2.2

What step the error happened?

None

Relevant information

The GA4 jobs were reporting as "Sync Succeeded", despite it actually having been broken days ago. As such 0 rows were being synced.

image

This is only apparent when I go into the connector and click "Retest saved source".

image

I am connecting via "Service Account Key Authentication" and the root cause was the the service user was deleted from the GA4 property during a manual clean up of access permissions by a different user last week.

Relevant log output

Log of "successful" (but 0 rows) sync included. 452c0be1_dcc4_422d_a8e8_c8b312c4ac42_logs_6169_txt.txt

2024-02-14 05:00:06 source > {
  "error": {
    "code": 403,
    "message": "User does not have sufficient permissions for this property. To learn more about Property ID, see https://developers.google.com/analytics/devguides/reporting/data/v1/property-id.",
    "status": "PERMISSION_DENIED"
  }
}

Contribute

marcosmarxm commented 9 months ago

Hello @gordonkjlee thanks for reporting this bug 🐛 . Are you only using custom reports in your connection?

gordonkjlee commented 9 months ago

Hello @gordonkjlee thanks for reporting this bug 🐛 . Are you only using custom reports in your connection?

No, a mix of custom and standard reports. But they all jointly failed without erroring