bigfunctions > is_email_valid

is_email_valid

Signature

is_email_valid(email)

Description

Return true if email is valid (inspired from this reddit answer)

Examples

1. with a valid email

EUUSeurope-west1

select bigfunctions.eu.is_email_valid('paul.marcombes@unytics.io')

select bigfunctions.us.is_email_valid('paul.marcombes@unytics.io')

select bigfunctions.europe_west1.is_email_valid('paul.marcombes@unytics.io')

+----------------+
| is_email_valid |
+----------------+
| true           |
+----------------+

2. with incorrect format

EUUSeurope-west1

select bigfunctions.eu.is_email_valid('paul/marcombes@example.com')

select bigfunctions.us.is_email_valid('paul/marcombes@example.com')

select bigfunctions.europe_west1.is_email_valid('paul/marcombes@example.com')

+----------------+
| is_email_valid |
+----------------+
| false          |
+----------------+

3. with a domain not registrable

EUUSeurope-west1

select bigfunctions.eu.is_email_valid('paul.marcombes@example.con')

select bigfunctions.us.is_email_valid('paul.marcombes@example.con')

select bigfunctions.europe_west1.is_email_valid('paul.marcombes@example.con')

+----------------+
| is_email_valid |
+----------------+
| false          |
+----------------+