Loading data into Aurora PostgreSQL Limitless Database

You can load data into Aurora PostgreSQL Limitless Database tables by using the COPY command or by using the data loading utility.

Note

You can load data into standard, sharded, and reference tables.

Contents

• Using the COPY command with Aurora PostgreSQL Limitless Database

  • Using the COPY command to load data into Aurora PostgreSQL Limitless Database

    • Splitting data into multiple files

  • Using the COPY command to copy Limitless Database data to a file

• Using the Aurora PostgreSQL Limitless Database data loading utility

  • Limitations

  • Prerequisites

  • Preparing the source database

  • Preparing the destination database

  • Creating database credentials

    • Create the source database credentials

    • Create the destination database credentials

  • Setting up database authentication and resource access using a script

    • Setup script for the data loading utility

    • Output from the data loading utility setup script

    • Cleaning up failed resources

  • Setting up database authentication and resource access manually

    • Creating the customer-managed AWS KMS key

    • Creating the database secrets

    • Creating the IAM role

    • Updating the customer-managed AWS KMS key

    • Adding the IAM role permission policies

  • Loading data from an Aurora PostgreSQL DB cluster or RDS for PostgreSQL DB instance

  • Monitoring data loading

    • Listing data loading jobs

    • Viewing details of data loading jobs using the job ID

    • Monitoring the Amazon CloudWatch log group

    • Monitoring RDS events

  • Canceling data loading