How to Fuzzy Match Datsets in Amazon Redshift

Using a Python UDF to allow fuzzy match joining in Amazon Redshift

Lewis Gavin
Towards Data Science
4 min readMar 28, 2019

--

Fuzzy Merging — Photo by Markus Spiske on Unsplash

If you’re lucky, when working with multiple datasets within your data warehouse there will be some kind of join column available for tables you want to bring together.

When this is the case, life is good. However modern Big Data solutions are opening…

--

--