Skip to content

Instantly share code, notes, and snippets.

@kerbelp

kerbelp/redshift_copy.sql

Last active December 4, 2016 22:21
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kerbelp/ba6d98d4959c306323da4dd35949f3d2 to your computer and use it in GitHub Desktop.
Save kerbelp/ba6d98d4959c306323da4dd35949f3d2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
redshift_copy.sql
COPY schema.table ("ts","column_a","column_b")
FROM 's3://bucket/prefix'
REGION 'us-east-1' /* S3 bucket is in us-east-1 region */
GZIP
ESCAPE;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment