I'm using Postgresql and want to use the levenshtein() function
Currently when I'm using it, it doesn't recognize the function
Is this something available within metabase's postgresql configuration?
My goal here is to implement fuzzy logic, which I couldn't find an option for in the Query Builder
Appreciate any help
WHEN levenshtein("Orders - Source"."customer_email"::text, "Orders - Source_2"."customer_email"::text) < 3 THEN 'Same Email'
hi, unfortuanately we don't call the custom db functions on the custom functions on the query builders. You can only use the db functions in SQL questions
I'm trying to use the function in the native SQL, the db I'm using is Postgresql
The issue is that the SQL engine isn't recognizing that function
Maybe this stack overflow question would help to elaborate what I'm talking about: sql - How to create simple fuzzy search with PostgreSQL only? - Stack Overflow
What happens when you run that SQL directly on Postgresql? Excluding metabase from the equation