Folder:
108 Data Analysis
File:
108.10.20.10.20.20 Data Analysis - Commands to move data from S3 to Redshift
Commands to move data from S3 to Redshift
The Redshift COPY command is how we move raw data from S3 to Newton. As explained in the "How we think about databases" section, the data should be copied into an appropriately named schema with the prefix raw_.
Every time I would use the COPY command, I would pop it into my notes. It often came in handy when data needed to be moved again.
Source:
- Me