{"uid":"cap_AYkUSH_o0gN2Qjfk9r-Qx","slug":"join-coverage-duplicate-key-report-and-numeric-distribution-a4cfa27e","name":"Join Coverage Duplicate Key Report and Numeric Distribution","description":"Join coverage — Duplicate key report + Numeric distribution: Duplicate key report + Numeric distribution for supplied join coverage records (matched_rows, source_rows). Up to 200 rows; 2 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 2 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-analytics-09-055?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","matched_rows","source_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"matched_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","source_rows":1,"matched_rows":10,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","source_rows":2,"matched_rows":20,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_rows":3,"matched_rows":15,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_rows":4,"matched_rows":30,"dataset_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["matched_rows","source_rows"],"type":"string","default":"matched_rows"}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_guLHZ49RkHtC7t6eaP-iQ","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Analyzes join coverage data (matched_rows, source_rows) to produce a duplicate key report and numeric distribution summary for up to 200 rows.","exampleAgentPrompt":"Run a duplicate key report and numeric distribution on my join coverage data — I have 4 rows with matched_rows and source_rows for groups 'group-a' and 'group-b' across dates 2026-10-01 to 2026-10-04, and I want to analyze the matched_rows field.","exampleUseCases":[{"title":"ETL pipeline join quality check","prompt":"I just ran a join between two tables and got these results — row-1 through row-4 across group-a and group-b, with matched_rows of 10, 20, 15, 30 and source_rows of 1, 2, 3, 4. Can you check for duplicate keys and show me the numeric distribution of matched_rows?"},{"title":"Dataset group match rate analysis","prompt":"I have daily join coverage records for October 2026 across two dataset groups and I want to understand how source_rows are distributed — run both a duplicate key check and a numeric distribution report on the source_rows field for my 4 rows."},{"title":"Data quality audit before pipeline merge","prompt":"Before I merge these datasets, can you run a duplicate key report and a numeric distribution check on my join coverage metrics? I have 4 records from group-a and group-b with matched_rows and source_rows values, and I want to audit the matched_rows column."}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying any repeated row IDs or key collisions in the supplied join coverage records, and (2) a numeric distribution summary (e.g. min, max, mean, percentiles, histogram bins) for the selected numeric field (matched_rows or source_rows), covering up to 200 input rows.","failureModes":["Input array empty or missing — returns validation error","More than 200 rows submitted — rejected with maxItems error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Numeric values outside allowed range (±1,000,000,000,000) — rejected","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) — schema error","Invalid field enum value (not 'matched_rows' or 'source_rows') — rejected"],"whenToPreferThis":"Choose this endpoint when you need both a duplicate key diagnostic and a numeric distribution analysis on join coverage data in a single paid call. It is purpose-built for ETL and data quality workflows where matched_rows and source_rows are the key metrics, and avoids the need for two separate API calls. Best for datasets up to 200 rows where local analytical computation is sufficient and no live data lookup or external enrichment is needed.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:38.689Z","isFirstParty":false,"canonicalSlug":"join-coverage-duplicate-key-report-and-numeric-distribution-a4cfa27e"}