- 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.
Created
August 2, 2013 15:18
-
-
Save tadasv/6140684 to your computer and use it in GitHub Desktop.
Redshift notes
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment