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.
If you are familiar with JSONPath, you can enter the path specification directly as well.
How it Works
- Upload a JSON or JSONL file. jsonl separates each record with a newline
- Create a new loader with this file and choose the Extract JSON transformation option on your JSON column
- This will launch the Lodr JSON Explorer
- Browse the explorer and click on attribute nodes you want to extract
- Lodr will expand any arrays into rows
Now there is nothing stopping you from getting the most out of your data!