"NULL result in a non-nullable column" error while inserting data from one snowflake table to other snowflake table using Talend Data Integration

[Anonymous]

Hello Team,

  I am creating a SCD2 flow without using SCD2 components(ex: SCDELT).

My source and target tables are in Snowflake database only.

Attaching my SCD2 flow.

I am trying to just insert the new records from source to target.

When i checked the SK and other column values in tLOGROW, they are all not null.

But while inserting data in Snowflake target, it is giving error as:"

"Caused by: net.snowflake.client.jdbc.SnowflakeSQLException: NULL result in a non-nullable column"

Only SK column has Not Null constraint.

Thank you.

[Anonymous]

Hello,

Are there empty strings in the source data? Could you please verify whether you have unchecked the below check box in tDBOutput(Snowflake)?

Best regards

Sabrina

[Anonymous · Accepted solution]

Hello,
Thank you for your help.
There was some issue with column names between source and target due to which error was coming in talend.
Issue is solved now.

Thank you