CODEWITHSUNDEEP
postgresqlamazon-web-servicesamazon-rdsamazon-aurora
shaikhspear
shaikhspear

Reputation: 616

Create Full AWS RDS Snapshot

Can I create a full database snapshot or backup (manual/automated) for Amazon RDS Postgres Databases and not incremental ones. I want to create a job that provides full database parquet files everyday and share it with the Data warehousing team.

The document here says the following:

The first snapshot of a DB instance contains the data for the full DB instance. Subsequent snapshots of the same DB instance are incremental, which means that only the data that has changed after your most recent snapshot is saved.

Upvotes: 1

Views: 613

Answers (1)

Marcin
Marcin

Reputation: 238199

The RDS snapshots do not create Parquet files, as they are based on EBS snapshots.

To get Parquet files the best way would be to setup a Glue job which can run automatically on your schedule.

Upvotes: 2

Related Questions