{"uid":"cap_tckrZ8wzINfOQYoEVHInd","slug":"join-coverage-analytics-exact-row-deduplication-and-keyed-dataset-5fc0c9ed","name":"Join Coverage Analytics — Exact Row Deduplication and Keyed Dataset Comparison","description":"Join coverage — Exact row deduplication + Keyed dataset comparison: Exact row deduplication + Keyed dataset comparison 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-053?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},"other":{"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":21,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_rows":3,"matched_rows":17,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_rows":4,"matched_rows":33,"dataset_group":"group-b"}],"maxItems":200,"minItems":0}}},"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_VVXfJOGzSAfDd7DwBEwST","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":"Performs exact row deduplication and keyed dataset comparison on two sets of join coverage records (matched_rows, source_rows), returning two independent analytical reports for up to 200 rows each.","exampleAgentPrompt":"I have two sets of join coverage records — one from last week's pipeline run and one from this week's — each with row_id, dataset_group, date, matched_rows, and source_rows fields. Can you deduplicate each set and compare them by key so I can see what changed between the two runs?","exampleUseCases":[{"title":"Pipeline run comparison for data engineers","prompt":"I ran my join pipeline on Monday and again on Wednesday. Here are the two sets of join coverage records with matched_rows and source_rows for each row_id. Can you deduplicate both and compare them keyed by row_id so I can see which rows changed, appeared, or disappeared between runs?"},{"title":"Duplicate row audit before reporting","prompt":"Before I publish this week's join coverage report, I need to make sure there are no duplicate rows in my dataset. Here are up to 200 records with row_id, date, dataset_group, matched_rows, and source_rows — can you run exact deduplication and flag any duplicates?"},{"title":"Cross-group join coverage discrepancy check","prompt":"I have join coverage data split across two dataset groups — group-a and group-b — and I want to compare them against each other by row_id and date to see where matched_rows or source_rows differ. Can you run the keyed comparison and give me a report on the discrepancies?"}],"resultDescription":"Returns two independent analytical reports: (1) an exact row deduplication report identifying duplicate rows within each supplied dataset, and (2) a keyed dataset comparison report highlighting differences between the two input datasets by row_id, dataset_group, and date fields including discrepancies in matched_rows and source_rows values. No external lookups or predictions are made; all analysis uses the supplied data only.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) — validation error","Malformed date format not matching YYYY-MM-DD pattern — schema validation failure","Empty rows array (minItems: 1 violated) — validation error","Numeric values outside allowed range (-1,000,000,000,000 to 1,000,000,000,000) — validation error","row_id exceeds 80-character maxLength — validation error"],"whenToPreferThis":"Choose this endpoint when you need offline, supply-data-only deduplication and keyed comparison of join coverage records (matched_rows, source_rows) with no external data fetching. Ideal for data engineers auditing ETL pipeline outputs, validating join coverage consistency between pipeline runs, or checking dataset snapshots for duplicate or divergent rows. Best suited for small-to-medium datasets (up to 200 rows per call) where two simultaneous analytical reports are needed cheaply at $0.01 USDC.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:42.938Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-exact-row-deduplication-and-keyed-dataset-5fc0c9ed"}