How can I migrate a jsonb column from postgres on RDS to S3?

Question

I have a table in a Postgres on RDS db with a jsonb column. I want to move this data to an S3 bucket and use federated queries to access this data. How can I do this?

Answer

Hi,

Thanks for posting to AWS re:Post. I wanted to share my two cents on the matter here.

In this case you can use DMS - JSONB is supported as a source in PostGreSQL engines.

[] Using a PostgreSQL database as an AWS DMS source - Source data types for PostgreSQL - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html#CHAP_Source-PostgreSQL-DataTypes

Then, you can refer->

[] Using Amazon S3 as a target for AWS Database Migration Service - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.S3.html

Hope this helps.

How can I migrate a jsonb column from postgres on RDS to S3?

Relevant questions