dataform-co / dataform

Dataform is a framework for managing SQL based data operations in BigQuery
https://cloud.google.com/dataform/docs
Apache License 2.0
853 stars 165 forks source link

All assertions fail when dry run #1776

Closed dali-rmw closed 4 months ago

dali-rmw commented 4 months ago

Hello, when I try to execute datafrom run --dry-run, all my assertions fail with the same error: BigQuery error: Cannot convert undefined or null to object. Example of an assertion create or replace view project.dataform_assertions.table_name_assertions_uniqueKey_0 as

SELECT * FROM ( SELECT row_id, col1, COUNT(1) AS index_row_count FROM TABLE_NAME GROUP BY row_id, col1 ) AS data WHERE index_row_count > 1