Data Science, Analytics, Databricks, Data Cleaning.
SELECT COUNT(*) FROM users_raw WHERE email IS NULL We can see that there are 847 null values in the email column 3) Check for duplicate values We can use the following query to check for duplicates: select count(*), * from users_raw group by user_id, user_first_touch_timestamp, email, updated