detect_free_email(email)
Detects if an <email> belongs to a free email service (e.g., Gmail, Yahoo, Outlook).
CREATE OR REPLACE FUNCTION `justfunctions.eu.detect_free_email`(`email` STRING)
RETURNS INT AS (justfunctions.eu.detect_free_email_domain(
justfunctions.eu.extract_url_domain_base(email)
))
OPTIONS ( description = '''Detects if an <email> belongs to a free email service (e.g., Gmail, Yahoo, Outlook).''')
Example
SELECT `justfunctions.eu.detect_free_email`("jason@gmail.com")
1