How to Handle Special characters and geometric datatypes in talend
Hi All,
I came across the below 2 errors while migrating Postgres DB to Snowflake through Talend. And I am doing a dynamic full load to Snowflake.
There are a few Tables and Columns having Special characters for which I am getting the below error: org.apache.Avro.SchemaParseException: Illegal character in: conces_$
And few Tables have Geometric data types like Polygone. Talend is not able to read those tables.
Please let me know if you have any alternative way of moving these.
NOTE:
I have Read-only access to Postgres through Talend
I have read and write access to Snowflake through Talend
I don't have direct access to these databases as they are Prod DB's.
