Validate email addresses using a regular expression.
This box provides a sample SQL query that can be used to assess whether or not a given email addresses is likely to be a valid email address.
This is accomplished using regex and other Presto string functions. This query does not test the mail server to validate if a mailbox actually exists at this address, but rather parses the email address string to see if the email address is properly formed.
Use-Cases
This script can be used to:
- Screen out invalid email addresses before sending them to downstream marketing lists
- Standardize email address data across data silos
- Provide clean data for ID Unification