Hi,
I’m trying to setup a destination via big que...
# troubleshootingj
james yang
03/19/2022, 10:03 AMHi,
I’m trying to setup a destination via big query, but I keep receiving this message. Any help would be appreciated, thank you.
com.google.gson.stream.MalformedJsonException: Use JsonReader.setLenient(true) to accept malformed JSON at line 1 column 1 path $
h
Harshith (Airbyte)
03/21/2022, 4:55 AMHey can you confirm the service account json is passed in the right way?
j
james yang
03/21/2022, 10:45 AM@Harshith (Airbyte) Hi Harshith, thanks for the reply. Is there a way for me to show you, but I follow the guide and should have it set up correct.
james yang
03/21/2022, 10:46 AMAlso set the roles for Editor +User
james yang
03/21/2022, 10:49 AMAlso had it set up this way
james yang
03/22/2022, 10:07 PMHarshith (Airbyte) Hey, any updates?
james yang
03/22/2022, 10:07 PM@Harshith (Airbyte) Hey, any updates?
h
Harshith (Airbyte)
03/23/2022, 5:03 AMThe only place we use json is the credentials JSON right? My hunch is that the json used there is not in right shape can you confirm that>
j
james yang
03/23/2022, 11:03 AM@Harshith (Airbyte) Just to make sure im putting the prive_key_id or should I put the private key?
james yang
03/23/2022, 11:26 AM@Harshith (Airbyte) I’m copying and pasting the Key Id inside the IAM & Admin -> Service Account -> Key Id
james yang
03/23/2022, 6:48 PM@Harshith (Airbyte) please let me know, thank you!
james yang
03/23/2022, 10:58 PM@Harshith (Airbyte) Can you show me what a successful json would look like?
m
Marcos Marx (Airbyte)
03/24/2022, 11:58 PM@james yang see one example
j
james yang
03/25/2022, 12:14 AM@Marcos Marx (Airbyte) Hey Marco, excuse my ignorance, but I’ve inputed the “private_key_id” as the credentials is that the right credentials JSON ID?
m
Marcos Marx (Airbyte)
03/25/2022, 12:15 AMno, you must paste the complete json object as showed in the image
j
james yang
03/25/2022, 12:38 AM@Marcos Marx (Airbyte) THAT WORK!!! Thank you so much 😭
16 Views