default application credentials giving error in Google Cloud VM - ODBC Drivers for Bigquery

[maneesh299]

So I am testing a SSIS package connecting to a Bigquery dataset. I have downled and installed the odbc driver from - https://cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers

Now I am getting the error as "Could not validate the GCE environment" by selecting the authentication as "application default credentials" The driver and the dsn is in a Google cloud VM and it is using a compute service account which i can see using the command gcloud auth list. Then I should not be getting this error?

[reinc]

Hi @maneesh299,

Welcome to Google Cloud Community!

The error "Could not validate the GCE environment; metadata server is inaccessible" indicates that the Simba ODBC driver is unable to communicate with Google Compute Engine's (GCE) metadata server.

Here are some workarounds on setting up the ODBC Driver For BigQuery:

Choose either User Authentication or Service Authentication:

• Change your OAuth Mechanism into User Authentication. Click Sign in and  Copy code from Google Sign page then paste into Confirmation Code to generate the Token.
  
  
• Or, Change your OAuth Mechanism into Service Authentication. Copy and paste the email address created on Service Account (ex. samplebq@1234.iam.gserviceaccount.com) and to get the Key File Path just click Browse and insert the downloaded json file. Check here on how to create a service account key and get the json file.

Lastly, Select your Default Catalog (Project) and Dataset. Test if it was successfully connected.

If your VM has lost access to the metadata server, it is recommended to Troubleshoot failed requests to the metadata server.


If the issue persists and you need further assistance , please feel free to reach out to our support team.

I hope the above information is helpful.