-- 1) Create raw table to hold incoming PAN values CREATE TABLE IF NOT EXISTS sgt_pan_numbers_dataset ( pan_number text ); -- 2) (Optional) Insert some test rows to ...

-- Create the stage table to store original given dataset drop table if exists stg_pan_numbers_dataset; create table stg_pan_numbers_dataset ( pan_number text ); -- 1. Identify and handle missing data ...