Skip to content

Instantly share code, notes, and snippets.

@rmarianski

rmarianski/gist:33457544050643ad24f121983b0b3c5e

Created November 1, 2016 15:44
Show Gist options
  • Save rmarianski/33457544050643ad24f121983b0b3c5e to your computer and use it in GitHub Desktop.
Save rmarianski/33457544050643ad24f121983b0b3c5e to your computer and use it in GitHub Desktop.
Download ZIP
redshift backfill
Raw
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment