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

0

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?

1 Answer
0

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.

AWS
EXPERT
answered 2 years ago
  • I still don't follow how to query the IR in postgres after moving to s3.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions