I have a simple table that has some data grouped by email addresses, and I would like to filter that table by email address domains that contain one of a pre-determined list of keywords.
Can this be achieved with an input table?
In a snowflake query, I achieved it this way -
where email like ‘%@%car%’
or email like’%@%truck%’
or email like’%@%airplane%
and the results would include emails like email@example.com and exclude emails like firstname.lastname@example.org