Sometimes you need to export RedShift to JSON, you can use Withdata DBToFile as to RedShift to JSON Exporter (Unloader / Extractor / Dumper).
Works GREAT in 2025.
Support Windows, Linux, and macOS.
Can run in GUI mode, Step by Step, just a few mouse clicks.
Can run in CLI (Command Line Interface), for Scheduled Tasks and Streams, for Automation.
After exporting RedShift to JSON in GUI, and Saving "RedShift to JSON" session, then you can: