Dynamic schema file load to Snowflake getting loaded with NULL values

vvazza10 — Fri, 15 Nov 2024 23:42:49 GMT

Hi ! I am trying to load a csv file to Snowflake by setting the column Type as Dynamic. I am getting below warning

[WARN ] org.talend.components.common.runtime.DynamicSchemaUtils- Incoming schema contains more columns than remote schema. Skipped columns: [Date_of_Event, Time_of_Event].

The table has 4 columns and the aforementioned columns in the warning gets populated with NULL values. Attached is the pipeline design and FILE_NAME_MAPPING component:

Please advise how to get values populated in the 2 fields.

Re: Dynamic schema file load to Snowflake getting loaded with NULL values

XJ_1630 — Tue, 21 Sep 2021 18:37:08 GMT

did you have a look at this ?

https://help.talend.com/r/KxVIhxtXBBFymmkkWJ~O4Q/3Z946y1CPIETo0zK8xGumw

topic Re: Dynamic schema file load to Snowflake getting loaded with NULL values in Talend Studio

Dynamic schema file load to Snowflake getting loaded with NULL values

Re: Dynamic schema file load to Snowflake getting loaded with NULL values