Forum Discussion

asl23's avatar
asl23
New Contributor
2 years ago

Cannot insert a NULL value into column error

Hi,

Hope you're well! Need your assistance here..

My pipeline reads from one table (source) and write into another one (target).

I get an error as below 'Cannot insert a NULL value into column sales_id'. i have double checked and i don't have any Nulls in the source table. 

 

1 Reply

  • SpiroTaleski's avatar
    SpiroTaleski
    Valued Contributor

    asl23 

    I guess you have null values for the unmatched records, so check the records after joining. 

    BR,

    Spiro Taleski