Insert into statement in OmnISci

insert_into_omnisci.sql

insert into baywheels_tripdata
select
duration_sec,
start_time,
end_time,
start_station_id,
start_station_name,
start_station_latitude,
start_station_longitude,
end_station_id,
end_station_name,
end_station_latitude,
end_station_longitude,
bike_id,
user_type,
member_birth_year,
member_gender,
case
when bike_share_for_all_trip is not null then bike_share_for_all_trip
when extracol = 'app' then 'No'
when extracol = 'clipper' then 'Yes'
end as bike_share_for_all_trip
from baywheels_tripdata_extracol;

--drop table with extracol, since it's been corrected and loaded into main table
drop table baywheels_tripdata_extracol;