AWS Exams GCP Exams Azure Exams GitHub Exams Jira Exams ISC2 Exams

Video: You added CONSTRAINT chk_positive CHECK databricks video

Question 1 Be Honest
« Back   Next data-analyst Question »
Answer

Full Certification Question

You added CONSTRAINT chk_positive CHECK (quantity > 0) to inventory_delta . A batch job now fails on MERGE with ERROR: CHECK constraint violated . How do you skip only the bad rows while still merging the rest?