Metadata.google.internal:80! System error

Ask the Community
1

Hi,

When trying to create a data connection, Goggle Sheets with the credentials settings GPC.

I keep on having the following issue:

{reason=Invalid HTTP response from metadata.google.internal:80! System error: UnknownHostException - metadata.google.internal: Name or service not known.

I’ve added the recommended egress policies. The information that was shared with me it was an API key, the project name, and the service account. I’m only using the API key as a JDBC property.

I believe I’m doing something not entirely correct on setting up the connection but I’m not able to find the documentation specific for this issue.

If you could guide me through it would be helpful.

2

That error is often associated with missing egress policies. Can you share more about your source setup / egress policies and where you are seeing this error?

3

Hi,

Yes, I’ve imported the egress policies mentioned here, being these the following:

Domain Required
accounts.google.com Always. Required for OAuth
googleapis.com Always

this is the configuration:

image
image700×809 49.7 KB

And this is where I’m having the issue:

image
image304×578 22.1 KB

image

Thank you for your help

4

Can you select JSON webtoken ans credential method instead of GCP instance credentials? (Unless of course this is running on an agent in GCP, which I think it’s not based on your screenshot.)

The hostname the code is trying to reach is probably available in GCP to hand out instance credentials.

1 Like
5

Had to ask to the API providers, according to him, it should be and agent in GCP.

Nevertheless I tried the JSON web token, I don’t have the OAuth JWT certificate, I tried to create it myself by inputting the information but still doesn’t work.

6

Hi,

Tried again the json web token recommendation with the agent, and it worked.

Thank you for your help