A lot of NoSQL and non-relational databases (like Mongo, Elastic Search etc) are able to store the data in the form of arrays, JSON and objects. In many cases, we would like to access this unstructured data for creating reports like bursting, flattening, finding key values etc. There are a couple of options which Helical
Users can now directly upload flat files like CSV, JSON, Parquet, TSV, Avro and Sequence Files to Helical Insight. Following steps need to be followed. Step 1: Download, install and start Apache Drill. To learn how to install Drill. Step 2: Configure the middleware to support flat files. Step 3: Go to Data Sources page.