Baywheels extra column schema

extra_col.sql

--201906 and 201907 files have extra blank column
CREATE TABLE baywheels_tripdata_extracol(
duration_sec INTEGER,
start_time TIMESTAMP,
end_time TIMESTAMP,
start_station_id SMALLINT,
start_station_name TEXT ENCODING DICT,
start_station_latitude FLOAT,
start_station_longitude FLOAT,
end_station_id SMALLINT,
end_station_name TEXT ENCODING DICT,
end_station_latitude FLOAT,
end_station_longitude FLOAT,
bike_id SMALLINT,
user_type TEXT ENCODING DICT,
member_birth_year SMALLINT,
member_gender TEXT ENCODING DICT,
bike_share_for_all_trip TEXT ENCODING DICT,
extracol TEXT ENCODING DICT
);

copy baywheels_tripdata_extracol from 's3://baywheels-data/201906-baywheels-tripdata.csv.zip';
copy baywheels_tripdata_extracol from 's3://baywheels-data/201907-baywheels-tripdata.csv.zip' with (delimiter=';');