Hey, I am trying to integrate GCP bigQuery as destination in Airbyte, but getting below error: Configuration check failed java.io.IOException: The Application Default Credentials are not available. They are available if running in Google Compute Engine. Otherwise, the environment variable GOOGLE_APPLICATION_CREDENTIALS must be defined pointing to a file defining the credentials. See https://developers.google.com/accounts/docs/application-default-credentials for more information. Can anyone help me to resolve this error?

The error message you're seeing suggests that Airbyte is unable to authenticate with Google Cloud Platform (GCP) because it can't find the necessary credentials. To resolve this, you need to provide the Service Account Key in JSON format during the BigQuery destination setup in Airbyte. Here's a step-by-step guide on how to do this: 1. Create a Service Account in your GCP and grant it the necessary permissions. For a production BigQuery instance, assigning the roles BigQuery Data Editor, and BigQuery Job User should be sufficient ([source](https://airbyte.com/tutorials/linkedin-ads-api-marketing-data-to-bigquery)). 2. Generate a Service Account Key for the Service Account you just created. Make sure to create the key in JSON format. Download the private key file once it's created. This is the only time Google will allow you to see its contents ([source](https://docs.airbyte.com/integrations/destinations/pubsub)). 3. In Airbyte, go to Destinations and click + New destination. Select BigQuery as the destination type. 4. Fill in the necessary details such as the Destination name, Project ID, Dataset Location, Dataset ID, and Loading Method. 5. For the Service Account Key JSON field, copy the entire content of the Service Account Key file you downloaded earlier and paste it into this field ([source](https://airbyte.com/tutorials/replicate-data-from-mysql-to-bigquery)). 6. Click on the setup connection button to verify the connection to the BigQuery destination. Remember to delete the Service Account Key file from your computer after you've successfully configured BigQuery as a destination in Airbyte for security reasons ([source](https://docs.airbyte.com/integrations/destinations/pubsub)). If you're still encountering issues, please refer to the [BigQuery destination connector documentation](https://docs.airbyte.com/integrations/destinations/bigquery) for more detailed instructions.

The summary is you’ll need to ensure you mount a Google service account key into the job container, which Google’s docs describe.

Thank you for your responses