PDF (US Ltr)
- 0.9Mb
7.2.2 Bulk Ingest Feature
Use the bulk ingest feature to import text files in bulk from an Amazon S3 bucket to a DB System in HeatWave on AWS in the same region. Bulk import is ideal for importing large tables.
This task requires the following:
- Access to AWS Management Console.
- Access to HeatWave Console.
- A client that is connected to the DB system. See Connecting to a DB System.
Do the following to bulk ingest data to a DB System:
- Create an IAM policy to access the Amazon S3 bucket. See Creating an IAM Policy to Access an Amazon S3 Bucket.
- Create an IAM role that grants the DB System access to read data from the desired Amazon S3 bucket. See Creating an IAM Role to Access an Amazon S3 Bucket.
- (Optional) If a MySQL user (and not a DB System administrator)
is importing data using the bulk ingest feature, grant the
LOAD_FROM_S3
privilege. See Granting Privileges to Bulk Ingest Data From Amazon S3. - Create a new DB System or edit an existing DB System, and enter the data import role ARN details. See Creating a DB System and Editing a DB System.
- Bulk ingest data from an Amazon S3 bucket. See Importing Data Using the Bulk Ingest Feature.
- Granting Privileges to Bulk Ingest Data From Amazon S3
By default, a DB System administrator has theLOAD_FROM_S3
privilege. However, if a user is importing data using the bulk ingest feature, theLOAD_FROM_S3
privilege is required. - Importing Data Using the Bulk Ingest Feature
- Bulk Ingest Limitations
Parent topic: Importing Data