<invoke name="query_sql"> <parameter name="sql">SELECT MIN(_ingestion_timestamp) AS first_ts, MAX(_ingestion_timestamp) AS last_ts, COUNT(DISTINCT _ingestion_timestamp) AS distinct_ts, COUNT(DISTINCT _batch_id) AS batches, COUNT(*) AS n FROM raw.Social_media_impact_on_life</parameter> <parameter name="purpose">Check whether the only true timestamp column carries any real time variation</parameter> <parameter name="source">raw</parameter> </invoke>