redshift backfill

gistfile1.txt

insert into tile_traffic_v4 (date, size, layer, x, y, z, format, api_key, status, total_ms, server, host, service)
select date, payload_size, layer, x, y, z, format, api_key, status, total_ms, server, 'vector.mapzen.com' as host, 'vector-tiles' as service
from vector_traffic_v2;

insert into tile_traffic_v4 (date, size, layer, x, y, z, format, api_key, status, total_ms, server, host, service, version, path)
select date, size, layer, x, y, z, format, api_key, status, total_ms, server, host, service, version, path
from tile_traffic_v3;