Redshift import JSON data

Want to import data from JSON file to Redshift?

Try Withdata FileToDB, a desktop JSON to Redshift converter for Windows, MacOS, and Linux, Convert JSON to Redshift, Easy and Fast.

Can run in GUI mode, Step by Step, just a few mouse clicks.
Can run in Command line, for Scheduled Tasks and Streams.
Import JSON to Redshift locally and privately, avoid uploading JSON file(s) to online services.
Support Windows, Linux, and macOS.

Import data from JSON file to Redshift

load JSON data to Redshift table - Choose Redshift and logon

Click “Wizard – 1 File To 1 Table” at task dialog.

import JSON data to Redshift table - task window

Select the “JSON” file type.

Import JSON file data to Redshift table - select file type

then show the wizard.

Support large ( > 4GB ) JSON file.

Import Data From JSON File To Redshift - open JSON file

Here is the file’s content.

Import Data From JSON File To Redshift - source JSON file

FileToDB will parse JSON file.

Load Data From JSON File To Redshift - select table

Transfer Data From JSON File To Redshift - preview

Import Data From JSON File To Redshift - import data

View imported data in Redshift table

Convert JSON to Redshift - view data