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

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

Anonymous — Sat, 22 Jun 2019 08:37:00 GMT

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.

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

Anonymous — Thu, 04 Jul 2019 09:27:07 GMT

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

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

Anonymous — Thu, 04 Jul 2019 09:31:09 GMT

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