Issue with Looker connector authentication

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

Facing authentication issue with Looker connector, receiving ‘Unable to connect to the Looker API. Please check your credentials.’ error message.


Question

Hi all,

I’m currently facing issues on the #Looker connector : https://docs.airbyte.com/integrations/sources/looker. When I’m feeding the config to the connector, I am facing the following “’Unable to connect to the Looker API. Please check your credentials.’“.

This issue is faced when trying to authenticate. However, when I’m trying to connect using the API and the same value, I’m receiving a 200.

Does anyone is facing the same issue while using this connector ? Thanks 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

["looker-connector", "authentication-issue", "api", "credentials"]
2

<@U037682LAD7> You might have an idea ?

I tried to run the test using the same config locally, it seems to work, but on Airbyte Cloud it does not work

3

I managed to create the source using the API, but I faced this issue when trying to create the connection :

2024-09-04 16:14:39 INFO i.a.c.i.LineGobbler(voidCall):166 - 
2024-09-04 16:14:39 INFO i.a.c.ConnectorWatcher(run):87 - Connector exited, processing output
2024-09-04 16:14:39 INFO i.a.c.ConnectorWatcher(run):90 - Output file jobOutput.json found
2024-09-04 16:14:39 INFO i.a.c.i.LineGobbler(voidCall):166 - ----- START DISCOVER -----
2024-09-04 16:14:39 INFO i.a.c.i.LineGobbler(voidCall):166 - 
2024-09-04 16:14:39 INFO i.a.c.ConnectorWatcher(run):96 - Connector exited with 1
2024-09-04 16:14:39 INFO i.a.w.i.VersionedAirbyteStreamFactory(create):189 - Reading messages from protocol version 0.2.0
2024-09-04 16:14:39 WARN i.a.m.l.MetricClientFactory(getMetricClient):43 - MetricClient has not been initialized. Must call MetricClientFactory.CreateMetricClient before using MetricClient. Using a dummy client for now. Ignore this if Airbyte is configured to not publish any metrics.
2024-09-04 16:14:39 ERROR i.a.w.i.VersionedAirbyteStreamFactory(internalLog):304 - 401 Client Error: Unauthorized for url: <https://theodo.cloud.looker.com/api/3.1/swagger.json>
Traceback (most recent call last):
  File "/airbyte/integration_code/main.py", line 13, in &lt;module&gt;
    launch(source, sys.argv[1:])
  File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/entrypoint.py", line 127, in launch
    for message in source_entrypoint.run(parsed_args):
  File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/entrypoint.py", line 112, in run
    catalog = self.source.discover(self.logger, config)
  File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/abstract_source.py", line 69, in discover
    streams = [stream.as_airbyte_stream() for stream in self.streams(config=config)]
  File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/abstract_source.py", line 69, in &lt;listcomp&gt;
    streams = [stream.as_airbyte_stream() for stream in self.streams(config=config)]
  File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/streams/core.py", line 66, in as_airbyte_stream```
4

Error: Unauthorized for url: <https://theodo.cloud.looker.com/api/3.1/swagger.json>

5

-> It is weird that it tries to reach the 3.1 API even though this API is deprecated

6

Can you confirm the version of connector you’re using?

7

Yeah I was on this - currently willing to open an issue.

I’m using Airbyte Cloud and I don’t know why but the available version is the 0.2.7

8

Great! Please open the issue and I can take it up from there.

9

I created the issue here :slightly_smiling_face: https://github.com/airbytehq/airbyte/issues/45129

Thanks !

10

<@U037682LAD7> Thanks a lot for your help, I managed to run my data sync using the connector without any problem :wink: