Skip to content

Instantly share code, notes, and snippets.

@tadasv

tadasv/redshift_notes.rst

Created August 2, 2013 15:18
Show Gist options
  • Save tadasv/6140684 to your computer and use it in GitHub Desktop.
Save tadasv/6140684 to your computer and use it in GitHub Desktop.
Download ZIP
Redshift notes
Raw
redshift_notes.rst

Migration

  • Altering tables requires exclusive lock on the table. If you have long running queries on a table plan ahead of time when is the right time to run the alter statements.
  • When loading data from S3 run COPY command with FILLRECORD, so that old data could be loaded if your table schema changes before your ETL process.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment