Error: Use JsonReader.setLenient(true) to Accept Malformed JSON

Issue

Setup tests fail. The following error appears:

Setup test BigQuery User Permissions failed: "exception": "java.io.UncheckedIOException: com.google.gson.stream.MalformedJsonException: Use JsonReader.setLenient(true) to accept malformed JSON at line 1 column 1 path

Environment

Destination: BigQuery

Resolution

To resolve this issue, ensure the Service Account Private Key you provide in the setup form is in JSON format. Specifically, you must provide the private key within braces or curly brackets ({}). See step 4 of our BigQuery setup guide for more information on the accepted format.

Cause

This issue occurs when the private key you provide in the destination connection setup form is incorrectly formatted.