Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
vikramk
Creator II
Creator II
‎2020-12-05 02:40 AM

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.

126 Views
0 Likes
0 Replies