LoadVoters.SQL

create temp table voters (
    name_prefix varchar(255),
    last_name varchar(255),
    first_name varchar(255),
    middle_name varchar(255),
    name_suffix varchar(255),
    race char(1),
    ethnicity varchar(255),
    party char(3),
    gender char(1),
    age int
);

copy voters
	from 's3://youwishiforgottodeletethis/voters.csv'
	credentials 'thistoo' 
	csv
	trimblanks
	blanksasnull
	ignoreheader as 1
	maxerror as 100;