HeatWave on AWS  /  ...  /  Granting Privileges to Bulk Ingest Data From Amazon S3

7.2.2.1 Granting Privileges to Bulk Ingest Data From Amazon S3

By default, a DB System administrator has the LOAD_FROM_S3 privilege. However, if a user is importing data using the bulk ingest feature, the LOAD_FROM_S3 privilege is required.

This task requires the following:
Do the following to grant the LOAD_FROM_S3 privilege to a user:
  1. Connect to the DB System. See Connecting to a DB System.
  2. Grant the LOAD_FROM_S3 privilege to the user:
    GRANT LOAD_FROM_S3 ON <Schema.Table> TO <User>