Environment
Analytics Database 25.3
Situation
Vertica EON is being configured, and documentation indicates that Vertica can access the S3 location defined as communal storage, allowing direct COPY operations from that S3 bucket.
A separate requirement involves loading files from another S3 bucket that uses a different endpoint, access key, and secret. The per‑bucket configuration documentation (https://docs.vertica.com/24.2.x/en/sql-reference/file-systems-and-object-stores/s3-object-store/per-bucket-s3-configs/#recommended-usage) provides partial guidance, but questions remain regarding management of S3BucketCredentials.
Documentation advises against storing credentials with ALTER DATABASE DEFAULT and instead recommends ALTER SESSION or alternative mechanisms. Because the load process is executed by an automated job, issuing ALTER SESSION before every file load is not feasible.
Guidance is requested on alternative supported methods for storing S3BucketCredentials, including whether a user‑level configuration mechanism exists. Only a single database user requires access to these credentials, so clarification is needed on whether any login‑level configuration parameter can be used to store them securely.
