Load GeoJSON file into redshift using copy command
Loading GeoJSON directly into a GEOMETRY
column is not currently supported. However, we will consider adding to our roadmap. When new features are released they are noted in our regular maintenance announcements at the top of the forum.
You can only COPY to GEOMETRY columns from data in text or CSV format. The data must be in the hexadecimal form of the extended well-known binary (EWKB) format … https://docs.aws.amazon.com/redshift/latest/dg/copy-usage_notes-spatial-data.html