Postgresql, Redshift, Etl, Transformation, Data Warehouse.
required. It will be a manual effort. When there are changes (additions, or changes in names of keys) in a JSON column, we’ll again have to manually create a column. If the schema changes and there’s no manual change, the data of the JSON will be queryable in Redshift — see this for JSON support in