Dynamic schema file load to Snowflake getting loaded with NULL values
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.