Skip to content

Instantly share code, notes, and snippets.

@taiwotman

taiwotman/rds_sql2.sql

Last active December 18, 2020 01:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save taiwotman/de9bbff64ef3e2289d9b6f1a0d4bc4e4 to your computer and use it in GitHub Desktop.
Save taiwotman/de9bbff64ef3e2289d9b6f1a0d4bc4e4 to your computer and use it in GitHub Desktop.
Download ZIP
AWS REDSHIFT SQL
Raw
rds_sql2.sql
COPY seattle_emergence_calls from 's3://seattle-realtime-emergence-fire-call/Seattle_Real_Time_Fire_911_Calls.csv' FORMAT CSV
IGNOREHEADER 1
CREDENTIALS 'aws_iam_role=your_iam_role'
REGION 'us-east-1';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment