What you can do is install a pure python library to interact with rds and run the commands via that library just like you would do with any normal python program. It is possible for you to add libraries like this to run in your glue job. In your case pg8000 would work like a charm
How to import postgresql database (.sql) file from AmazonS3 to AWS RDS?
I am very new to AWS, and Postgresql.
I have created a database using PgAdmin4 and added my data to the database.
I have created a backup file of my database i.e. .SQL file.
I have created a database instance on AWS RDS.
I have uploaded my database file and several documents s3 bucket.
I tried to integrate AWS S3 and RDS database using AWS Glue, but nothing is working for me. I am not able to figure out how to integrate S3 and RDS for importing and exporting datafrom S3 to RDS and vice versa.
Can you please tell me how can I set up RDS and S3?
How to import postgresql database (.sql) file from AmazonS3 to AWS RDS?