How to load table with JSONB data type into Aurora PostgreSQL using AWS Glue

Photo by Nam Anh on Unsplash

In this blog post I will cover what is JSON data type, what options does PostgreSQL offers to store JSON data, how you can create AWS Glue connection to Aurora PostgreSQL database running in private subnet and how can you then use AWS Glue to write data into table with JSONB datatype into Aurora/RDS PostgreSQL database.