Loading Data

Better Support for S3 Session Parameters

When you read from S3 using COPY FROM with S3 URLs, Vertica uses the configuration parameters described in AWS Parameters. Previously, these parameters could be set only globally, which made it harder to read from different regions or with different credentials in parallel. You can now set these parameters at the session level using ALTER SESSION.

In addition, if you use ALTER SESSION to set an AWS parameter, Vertica automatically sets the corresponding UDParameter used by the UDSource described in Exporting Data From Amazon S3 Using the AWS Library.

For more information, see the section about S3 in Specifying COPY FROM Options.