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.
Solved! Go to Solution.
Are there empty strings in the source data? Could you please verify whether you have unchecked the below check box in tDBOutput(Snowflake)?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables