Resolving encoding error in `datahub-datahub-gms` pod when ingesting from Snowflake

Original Slack Thread

Hi there, datahub-datahub-gms pod is throwing an encoding related error when I try to ingest from an external source (Snowflake):
Caused by: java.sql.SQLException: Incorrect string value: '\xE2\x94\x81\xE2\x94\x81...'
Any idea how I can get around that other than changing the encoding settings on the database?

https://datahubspace.slack.com/archives/C029A3M079U/p1695360161393249

Solved by removing characterEncoding=UTF-8 from the SQL connection that’s documented here for setting up Datahub to use AWS RDS:
https://datahubproject.io/docs/deploy/aws/