RDS Export Task

An RDS Export Task in AWS allows you to export data from an Amazon RDS or Aurora snapshot to Amazon S3 in Apache Parquet format. This enables efficient querying and analysis of database snapshot data using services like Amazon Athena, Redshift Spectrum, or EMR without needing to restore the snapshot to a database instance.

aws.rds_export_task

Fields

TitleIDTypeData TypeDescription
_keycorestring
account_idcorestring
export_onlycorearray<string>The data exported from the snapshot or cluster. Valid Values: database - Export all the data from a specified database. database.table table-name - Export a table of the snapshot or cluster. This format is valid only for RDS for MySQL, RDS for MariaDB, and Aurora MySQL. database.schema schema-name - Export a database schema of the snapshot or cluster. This format is valid only for RDS for PostgreSQL and Aurora PostgreSQL. database.schema.table table-name - Export a table of the database schema. This format is valid only for RDS for PostgreSQL and Aurora PostgreSQL.
export_task_arncorestring
export_task_identifiercorestringA unique identifier for the snapshot or cluster export task. This ID isn't an identifier for the Amazon S3 bucket where the data is exported.
failure_causecorestringThe reason the export failed, if it failed.
iam_role_arncorestringThe name of the IAM role that is used to write to Amazon S3 when exporting a snapshot or cluster.
kms_key_idcorestringThe key identifier of the Amazon Web Services KMS key that is used to encrypt the data when it's exported to Amazon S3. The KMS key identifier is its key ARN, key ID, alias ARN, or alias name. The IAM role used for the export must have encryption and decryption permissions to use this KMS key.
percent_progresscoreint64The progress of the snapshot or cluster export task as a percentage.
s3_bucketcorestringThe Amazon S3 bucket where the snapshot or cluster is exported to.
s3_prefixcorestringThe Amazon S3 bucket prefix that is the file name and path of the exported data.
snapshot_timecoretimestampThe time when the snapshot was created.
source_arncorestringThe Amazon Resource Name (ARN) of the snapshot or cluster exported to Amazon S3.
source_typecorestringThe type of source for the export.
statuscorestringThe progress status of the export task. The status can be one of the following: CANCELED CANCELING COMPLETE FAILED IN_PROGRESS STARTING
tagscorehstore
task_end_timecoretimestampThe time when the snapshot or cluster export task ended.
task_start_timecoretimestampThe time when the snapshot or cluster export task started.
total_extracted_data_in_gbcoreint64The total amount of data exported, in gigabytes.
warning_messagecorestringA warning about the snapshot or cluster export task.