Scenario

A social media company stores user information including email addresses and phone numbers, and needs to protect user privacy before sharing the data.

Task

Write a Snowflake SQL query that:

1. Reads from {{ ref("input_df") }}
2. Extracts the domain name from the email column (everything after the @ symbol) and aliases it as email_domain
3. Anonymizes the phone column by replacing the first 6 digits with asterisks (******) and keeping the last 4 digits, aliased as anon_phone
4. Returns user_id, email_domain, and anon_phone

Schema

input_df

Example

input_df:

Expected Output:

Note: The email domain is the portion after the @ symbol. The phone is masked so that only the last 4 digits are visible.