cross_db_overlap
Compare a field across two databases to identify overlapping values, bypassing cross-database join limits by computing intersections in memory.
Instructions
Compare a field across two databases to find overlapping values (e.g. find which email addresses exist in both your CRM and marketing databases). Handles cross-DB join limitations by fetching both sets and computing intersection in memory. Caps at 500K rows per side — add filters for larger tables. Supports cancellation.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| filter_a | No | MBQL filter for source A | |
| filter_b | No | MBQL filter for source B | |
| source_a | Yes | First source: { database_id, table_id, field_id } | |
| source_b | Yes | Second source: { database_id, table_id, field_id } | |
| sample_size | No | Return this many sample overlapping values (default 0, max 50) |