Easiest way is to use COPY command. Details and examples are [here] (https://docs.aws.amazon.com/redshift/latest/dg/r_COPY.html).
Alternately, you create an external table using Redshift Spectrum and then use 'Insert Into Select from' in Redshift to load this external table data into Redshift core table.
- asked 4 years ago
- asked a year ago
- How do I run SQL commands on an Amazon Redshift table before or after writing data in an AWS Glue job?AWS OFFICIALUpdated 3 months ago
- Why does a table in an Amazon Redshift cluster consume more or less disk storage space than expected?AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 8 months ago
- EXPERTpublished 2 months ago
- EXPERTpublished 5 days ago
You can, also , use the query editor V2 to generate the Copy command for you and load the data in your table, as shown in this video: https://www.youtube.com/watch?v=NWKS8teMmVw