Error setting up destination connection to BigQuery from Redshift


Unable to establish destination connection to BigQuery from Redshift due to a configuration check failure with a specific error related to malformed JSON


Hello All,
I was able to establish a source connection to Redshift but unable to setup destination - BigQuery. Can anyone help? Here is the error
Configuration check failed Use JsonReader.setLenient(true) to accept malformed JSON at line 1 column 1 path $

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["redshift", "bigquery", "destination-connection", "configuration-check", "malformed-json"]

While it looks like it’s malformed json that BQ is complaining about, I see some stack overflow posts indicating it could be related to java and networking and headers. So maybe worth checking there’s not malformed json in the source somewhere, it may also be worth checking your auth setup and that it’s able to connect and run “test” when you configure the destination. or even some BQ access or firewall setting that’s causing it to return something different when data actually gets pushed in, from whatever it returns when the connection gets tested.