COPY - Amazon Redshift

Amazon Redshift Spectrum external tables are read-only. You can't COPY to an external table. The COPY command appends the input data as additional rows to the table. The maximum size of a single input row from any source is 4 MB. COPY table-name [ column-list ] FROM data_source authorization [ [ FORMAT ] [ AS ] data_format ] [ parameter [ argument ] [, ... ] ] You can perform a COPY operation with

[yass]

" 's3://copy_from_ssh_manifest_file' The COPY command can connect to multiple hosts using SSH, and can create multiple SSH connections to each host. COPY executes a command through each host connection, and then loads the text output from the commands in parallel into the table. "