1 Answer
- Newest
- Most votes
- Most comments
1
You could create a view in Postgres that extracts the elements from your JSON column as discrete columns and then query the view from Redshift. With this solution, no column of data exceeds 64K so you'll be able to query the data properly in Redshift.
Relevant content
- asked 7 months ago
- asked 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a month ago
- AWS OFFICIALUpdated a year ago
Thanks for the answer! That's great solution, unfortunately in my case there is no ability to create new objects in source Postgres db.