[FAQ] Why row counts must be computed in the database

[AsherJD-io]

Course

data-engineering-zoomcamp

Question

Why can’t row count questions in Homework 2 be answered directly from Kestra execution logs?

Answer

Kestra orchestrates workflows but does not automatically aggregate dataset-level metrics such as total row counts across multiple executions. Questions involving total rows for a full year or specific months require querying the target database after ingestion. In Homework 2, accurate row counts were obtained using SQL queries against PostgreSQL tables populated by the Kestra flows.

Checklist

• I have searched existing FAQs and this question is not already answered
• The answer provides accurate, helpful information
• I have included any relevant code examples or links

[github-actions]

✅ FAQ NEW proposal created in PR #131

Please review and approve the changes.