title: Export JSON data and load into a Relational Database
body: <p>Is there a standard way of converting JSON data to relational database with multiple tables? We need to export our data from a MongoDB instance and import them into a Redshift cluster. The only problem is that some of MongoDB fields contain objects and arrays. Redshift cluster accepts CSV so I'm thinking the output would be at least one CSV file for each new table.</p>
  
  <p>I don't need specific implementation. I just wanted to know the concepts on how to efficiently transform the JSON/NoSQL data into relational format.</p>