QuestionQ98

VerifiedData Ingestion and Transformation

A company reads data from customer databases running on Amazon RDS. The databases contain many inconsistent fields. For example, a customer-record field named place_id in one database is named location_id in another database. The company must link customer records across different databases, even when customer-record fields do not match.

Which solution meets these requirements with the LEAST operational overhead?

Explanation

AWS Glue FindMatches is a managed record-matching ML transform that identifies duplicate or matching records even when no common unique identifier exists and fields do not match exactly. It is specifically suited to linking customer records across databases. AWS Glue crawlers discover and catalog the database schemas, and teaching, evaluating, and tuning the managed transform avoids operating EMR infrastructure or developing a custom Spark ML solution.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!