COPY FROM
supports many convenience features such as schema discovery or metadata filtering, and can easily adapt to different data loading workflows.COPY FROM
.AWS_ACCESS_KEY_ID
and AWS_SECRET_ACCESS_KEY
parameters of the respective SQL command or function (e.g. CREATE LOCATION, CREATE EXTERNAL TABLE, or read_iceberg(..)).
COPY TO
due to the added cost of serializing and transferring data to the client.