Improve error messages for YouTube Analytics source

[nataliekwong]

Improve the error messages emitted for the Youtube Analytics source.

Error Type: Not sure

The Youtube account is not valid. Please make sure you're trying to use the active Youtube Account connected to your Google Account.

Suggestion: Not sure at this time - need more information on why this error message shows up.

[jovezhong]

+1

[gregonarash]

@jovezhong @nataliekwong

I was facing the same issue described here by @jovezhong https://github.com/airbytehq/airbyte/issues/32433

The error account not valid:

The Youtube account is not valid. Please make sure you're trying to use the active Youtube Account connected to your Google Account.

Seem to be generated by this piece of connector code:

    def check_connection(self, logger, config) -> Tuple[bool, any]:
        authenticator = self.get_authenticator(config)
        jobs_resource = JobsResource(authenticator=authenticator)
        result = jobs_resource.list()
        if result:
            return True, None
        else:
            return (
                False,
                "The Youtube account is not valid. Please make sure you're trying to use the active Youtube Account connected to your Google Account.",
            )

https://github.com/airbytehq/airbyte/blob/6fce769ce3a5e131b04ec60e4a9c5de5330b2806/airbyte-integrations/connectors/source-youtube-analytics/source_youtube_analytics/source.py#L266

I am just figuring out this API - so making some assumptions:

• Airbyte YouTube Analytics is actually accesing YouTube Reporting API ( different from Analytics API)
• YouTube Reporting API - requires reporting jobs to be created. I am guessing that if you use this first time jobs_resource.list() will be always empty.
• I have executed via Google API explorer jobs.create Method and the Airbyte error has disappeared

https://developers.google.com/youtube/reporting/v1/reference/rest/v1/jobs/create?apix_params=%7B%22prettyPrint%22%3Atrue%2C%22resource%22%3A%7B%22reportTypeId%22%3A%22channel_annotations_a1%22%2C%22name%22%3A%22tst1%22%7D%7D

I cannot say yet if the Airtbyte connector gets all the reports with data or only the one for which I called jobs.create. Might need to wait 24 hours for report to be generated.