DuckDB

Asset check fails when target table contains zero rows

warning
availabilityUpdated Mar 24, 2026
How to detect:

When an asset check executes against a DuckDB table and the SELECT COUNT(*) query returns 0, the check fails with AssetCheckResult(passed=False). This indicates the asset materialization did not populate the table with expected data.

Recommended action:

1. Navigate to Asset Details page for the asset and select the Checks tab to view check results. 2. Query the table directly using DuckDB connection to verify row count. 3. Review the asset materialization logs to identify why no data was written. 4. Check upstream data sources and dependencies. 5. Click Execute in the UI to manually re-run the check after remediation.