<invoke name="query_sql"> <parameter name="sql">SELECT COUNT(*) AS row_count, MIN(_ingestion_timestamp) AS first_ingested, MAX(_ingestion_timestamp) AS last_ingested, COUNT(DISTINCT _batch_id) AS batches, COUNT(DISTINCT _source_file) AS source_files FROM raw.iris</parameter> <parameter name="purpose">Confirm row count and the span of the only temporal column (ingestion timestamp)</parameter> <parameter name="source">raw</parameter> </invoke> ``` <invoke name="query_sql"> <parameter name="sql">SELECT COUNT(*) AS column_count FROM meta.columns WHERE table_name = 'iris'</parameter> <parameter name="purpose">Confirm column count</parameter> <parameter name="source">raw</parameter> </invoke>