Prepare and Load JSON files into Redshift

Lodr Feature Highlight

JSON is the lingua franca of modern applications. There isn't an API worth it's salt that doesn't support JSON.

The problem though is the semi-structured nature of JSON. This makes JSON difficult to work with in analytical settings. Interesting bits of data could be at unpredictable levels of depth with arbitrary sets of attributes. Even though Redshift has support for JSON data, it is not as intuitive as being able to visually explore a JSON structure while plucking relevant attributes.

Now with Lodr you can now visually browse JSON objects and extract meaningful data points with a few clicks. The days of struggling with nested JSON objects are over. Getting JSON data into Redshift has never been easier.

Extract json load redshift

If you are familiar with JSONPath, you can enter the path specification directly as well.

How it Works

  1. Upload a JSON or JSONL file. jsonl separates each record with a newline
  2. Create a new loader with this file and choose the Extract JSON transformation option on your JSON column
  3. This will launch the Lodr JSON Explorer
  4. Browse the explorer and click on attribute nodes you want to extract
  5. Lodr will expand any arrays into rows

Now there is nothing stopping you from getting the most out of your data!

You can load 10K rows per month for free or upto 2 Million rows for $19! Own your data destiny.