Hey all, I am trying to set up BigQuery as a desti...
# ask-community-for-troubleshootings
Sam Wiltshire
05/13/2022, 12:25 PMHey all, I am trying to set up BigQuery as a destination and I am getting the following error which is stumping me:
m
Marcos Marx (Airbyte)
05/13/2022, 12:28 PMPlease check your service account format, it should be a json value
s
Sam Wiltshire
05/13/2022, 12:37 PMThanks, I have resolved that and am now getting:
Sam Wiltshire
05/13/2022, 12:37 PMFYI, I have created the HMAC key
m
Marcos Marx (Airbyte)
05/13/2022, 12:41 PM😅 did you paste the key and secret in right place? I think for bigquery they are flipped and I (a few times) pasted wrongly
s
Sam Wiltshire
05/13/2022, 1:52 PMI think I got them the right way around the first time, but swapped them anyway to try and got the following:
Sam Wiltshire
05/13/2022, 1:52 PMGiven this is a 403 vs a 404 I think the first time around was correct
Sam Wiltshire
05/13/2022, 1:52 PMBut could be wrong
Sam Wiltshire
05/13/2022, 2:55 PMI can't seem to get it working so I have switched over to standard INSERT statements and that seems to work