<invoke name="query_sql"> <parameter name="sql">SELECT COUNT(*) AS n, COUNT(DISTINCT Id) AS distinct_ids, MIN(Id) AS min_id, MAX(Id) AS max_id, COUNT(SepalLengthCm) AS sl_nn, MIN(SepalLengthCm) AS sl_min, MAX(SepalLengthCm) AS sl_max, AVG(SepalLengthCm) AS sl_avg, STDDEV(SepalLengthCm) AS sl_sd, COUNT(SepalWidthCm) AS sw_nn, MIN(SepalWidthCm) AS sw_min, MAX(SepalWidthCm) AS sw_max, AVG(SepalWidthCm) AS sw_avg, STDDEV(SepalWidthCm) AS sw_sd, COUNT(PetalLengthCm) AS pl_nn, MIN(PetalLengthCm) AS pl_min, MAX(PetalLengthCm) AS pl_max, AVG(PetalLengthCm) AS pl_avg, STDDEV(PetalLengthCm) AS pl_sd, COUNT(PetalWidthCm) AS pw_nn, MIN(PetalWidthCm) AS pw_min, MAX(PetalWidthCm) AS pw_max, AVG(PetalWidthCm) AS pw_avg, STDDEV(PetalWidthCm) AS pw_sd, COUNT(Species) AS sp_nn, COUNT(DISTINCT Species) AS sp_distinct, COUNT(DISTINCT _source_file) AS files, COUNT(DISTINCT _batch_id) AS batches, COUNT(DISTINCT _source_system) AS systems FROM raw.Iris</parameter> <parameter name="purpose">Profile nulls, ranges, spread, key uniqueness and categorical cardinality in one pass</parameter> </invoke> <parameter name="source">raw</parameter> </invoke> <parameter name="args">{}</parameter> </invoke>