AWS Entity Resolution

The AWS Entity Resolution matching workflow is designed to identify and resolve overlaps or duplicates across multiple datasets using advanced matching algorithms, making it more efficient for large and complex data than manual methods like SQL queries. While SQL queries in AWS Clean Rooms can help detect overlaps, the matching workflow in AWS Entity Resolution is tailored for this purpose and is likely to be more accurate and scalable, especially for datasets with slight variations in the data fields.

The AWS ER service has two capabilities for matching workflows. Rule based and ML based matching techniques. If you want to understand with more control to validate your scenarios, I would recommend to use Rule based matching workflows. To your question on how the matching workflow works- When you create a matching workflow, AWS ER reads your data from your specified source location and finds a match between two or more records. It then assigns a ‘Match Id’. `to the records in the matched set. The output will be written to your target output location.