SNOW-CSA Reporting, SLA and Imports Practice Question

Correct answer & explanation

The import fails with a 'Null reference' error because the script in the field mapping uses a query that does not find a matching record in the target table, resulting in a null value for the reference field. Option A is correct: the script is likely not using the correct record identifier (e.g., sys_id or a unique field) to locate the target record, so the query returns no results. Option B is incorrect because read-only fields do not cause null reference errors; they prevent field updates. Option C is incorrect because 'Atomic update' mode is unrelated to reference field errors; it affects how transforms are processed. Option D is incorrect because the coalesce field determines how source rows are matched to target rows, but the error here occurs during field mapping execution, not during coalescing.