https://community.qlik.com/t5/Talend-Studio/How-to-Handle-Special-characters-and-geometric-datatypes-in/m-p/2310830#M81918 <P>Hi All,</P><P>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.</P><UL><LI>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_$</LI><LI>And few Tables have Geometric data types like Polygone. Talend is not able to read those tables.</LI></UL><P>Please let me know if you have any alternative way of moving these.</P><P><B><U>NOTE:</U></B></P><UL><LI>I have Read-only access to Postgres through Talend</LI><LI>I have read and write access to Snowflake through Talend</LI><LI>I don't have direct access to these databases as they are Prod DB's.</LI></UL><P></P><P></P> Sat, 16 Nov 2024 00:59:52 GMT vikramk 2024-11-16T00:59:52Z https://community.qlik.com/t5/Talend-Studio/How-to-Handle-Special-characters-and-geometric-datatypes-in/m-p/2310830#M81918 <P>Hi All,</P><P>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.</P><UL><LI>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_$</LI><LI>And few Tables have Geometric data types like Polygone. Talend is not able to read those tables.</LI></UL><P>Please let me know if you have any alternative way of moving these.</P><P><B><U>NOTE:</U></B></P><UL><LI>I have Read-only access to Postgres through Talend</LI><LI>I have read and write access to Snowflake through Talend</LI><LI>I don't have direct access to these databases as they are Prod DB's.</LI></UL><P></P><P></P> Sat, 16 Nov 2024 00:59:52 GMT https://community.qlik.com/t5/Talend-Studio/How-to-Handle-Special-characters-and-geometric-datatypes-in/m-p/2310830#M81918 vikramk 2024-11-16T00:59:52Z