Summary
The user is facing errors with the Google Search Console connector in Airbyte when trying to sync data to a PostgreSQL database. The errors include a duplicate key violation in PostgreSQL and a missing authentication credential error from the Google Search Console API.
Question
I’ve created a connector whose source is “Google Search Console” and destination is a PostgreSQL database.
I’m using Airbyte version 0.44.4.
I’ve activated all the connector’s feeds in “incremental deduped” mode and chosen a “normalized tabular data” type of normalization.
On the 1st attempt, I get an error message “Failure Origin: destination, Message: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint “pg_class_relname_nsp_index” Detail: Key (relname, relnamespace)=(search_analytics_site_report__site_url_date_country_device__idx, 16425) already exists.”.
On the 2nd attempt, I get another error message “Failure Origin: source, Message: Request is missing required authentication credential. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.”, and the 3rd attempt looks very similar to the 2nd.
So far, it’s a connector I’ve used before without any problems.
In the end, some tables did contain clean data (search_analytics_all_fields and all search_analytics_by_XXX tables) and other feeds clearly crashed, such as “search_analytics_keyword_page_report” or “search_analytics_keyword_site_report_by_site”.
Have there been any recent changes to this Google Search Console connector?
Does anyone have a clue about this problem?
Thanks for any answers or suggestions
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.