Hello team, I am trying to setup bigquery as destination, Its working fine when i go with standard inserts but getting error as follows when i use gcs staging

State code: NoSuchKey; Message: The specified key does not exist. (Service: Amazon S3; Status Code: 404; Error Code: NoSuchKey; Request ID: null; S3 Extended Request ID: null; Proxy: null)

• airbyte version : 0.40.28 • Bigquery version : 1.2.9 Please let me know if anyone faced this issue. Orelse please help me solve this issue

Hello, Based on the information provided, it seems like you're encountering an issue with the GCS HMAC Key configuration when trying to use GCS Staging as a loading method for BigQuery. This error message typically indicates that the specified key does not exist in the S3 bucket. However, in this context, it's likely referring to the GCS HMAC Key. Here are a few things you can check: 1. HMAC Key Configuration: Ensure that the HMAC Key is correctly configured. The error message suggests that there might be an issue with the key. 2. Permissions: The HMAC Key should have permissions to write to the bucket. It needs to have Storage Object Admin permission. 3. Service Account: Check if the service account associated with the HMAC Key has the correct permissions. 4. Bucket Existence: Make sure that the specified bucket actually exists in your GCS. 5. Airbyte & Connector Version: You're using Airbyte version

0.40.28

. Check if there are any known issues with this version related to GCS Staging. Also, ensure that your BigQuery connector is up-to-date. If you've checked all of these and the issue persists, it might be a bug in Airbyte. In such a case, you can raise a ticket for timely resolution. For more details, you can refer to these discussions where similar issues were encountered: [Slack Conversation](https://airbytehq.slack.com/archives/C021JANJ6TY/p1664865940462849), [Forum Discussion](https://discuss.airbyte.io/t/3896). I hope this helps! Let me know if you have any other questions.

@kapa.ai I already checked these thing, Don’t have luck in these cheking Can you please suggest me any other solution

I'm sorry to hear that you're still experiencing issues. Based on the information provided, here are a few additional steps you can take: 1. Check the specific connector troubleshooting guides: For example, if you're using the Jira or Shopify connectors, you can check out the common troubleshooting issues for these connectors on the [Airbyte Forum](https://github.com/airbytehq/airbyte/discussions). 2. Reach out to the Airbyte community: You can post your issue on the Airbyte Slack channels. There are different channels for different types of issues, such as

#help-connections-issues

,

#help-infrastructure-deployment

,

#help-connector-development

,

#help-api-cli-orchestration

, and

#help-contributions

. You can access Airbyte Slack [here](https://slack.airbyte.com/). 3. Open a Github ticket: If you're still unable to resolve the issue after reaching out to the community, it's time to open a support ticket. The Airbyte support team is here to help you with any issues you're facing with Airbyte. 4. Consider Airbyte's premium support packages: If you require additional assistance beyond what is provided by the community, Airbyte offers premium support packages. Remember to provide as much detail as possible when reaching out for help. This includes the Airbyte version you're using, the source and destination connectors and their versions, and a detailed description of the issue and any error messages you're seeing. This will help the community and the support team to better understand and resolve your issue.