JSON Data in the Destination Contains Unexpected Backslash Characters

Issue

JSON data in the destination contains unexpected backslash characters.

Environment

Fivetran Connector SDK

Resolution

To resolve this issue, avoid sending JSON data as a STRING data type.

For example, if you have declared the receiving column as a JSON data type in your schema(), avoid using the json.dumps() function to convert your data. Instead, pass the JSON data directly to the operation call.

Cause

This issue occurs when your JSON data gets converted to STRING data type. When this happens, your data may encounter formatting issues and additional backslash characters.