Trouble connecting Airbyte to BigQuery project with MalformedJsonException

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

When attempting to connect Airbyte to a BigQuery project, encountering a MalformedJsonException error. Looking for a solution.


Question

Hey all!

I’m attempting to connect AirByte to a BigQuery project, but I’m encountering a problem:

com.google.gson.stream.MalformedJsonException: Use JsonReader.setLenient(true) to accept malformed JSON at line 1 column 1 path $
I already searched through some documentation and this Slack channel, but I couldn’t find an answer to this. Does anyone know how to solve this?


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

["airbyte", "bigquery", "malformedjsonexception", "connector"]
2

Is this during the connector creation? Maybe is a malformatted JSON like the service account one

3

are you literally copying and pasting the json file’s content to the correct field in the UI? or are you trying to pass these programmatically somehow?

4

yes, it is. I’m experiencing multiple problems with BQ account permission and malformatted JSON. Do you have any suggestion to solve this problem? <@U02TQLBLDU4>