Nimbus Intelligence Super JSON Flattener and Auto Caster

The Nimbus Intelligence Super JSON Flattener and Auto Caster application provides an easy way to transform semi-structured JSON data into properly typed columns.

Overview

Originally designed to work in conjunction with Nimbus Intelligence Connectors, the application can handle JSON from any source. Build a dynamic view on top of changing semi-structured data that will automatically update, or create one-time static tables. Use our intuitive GUI or call the available procedure as part of your custom pipelines.

The application has the following key features:

Universal JSON flattener: Wherever your semi-structured data is sourced from, our flattener will parse it into columnar format tables ready for SQL queries.
Automatic casting to datatypes: Numeric values, text, booleans and timestamp type data are all automatically determined by our autocaster, even in mixed-type or null-holding columns.
Dynamic view building: Build a view once and require no further action when new entries are added to the semi-structured source data, or build one-time static tables if preferred,
Intuitive GUI or ready-to-call procedure: Add, save and load configurations in the accessible Streamlit-powered user interface, or use the available stored procedure to integrate the flattener and auto caster in your custom pipelines.

Data Governance

At no point, any of your account’s specific data is being accessed. Moreover, the data that gets flattened and cast does never leave your account, and it is in no way accessible or readable by us.

To make sure the user keeps control over his data, the app provides extensive logs which keeps track off each step the app executes.

All the required objects for the functioning of the app will be saved in the database and schema of your choice. The procedures, functions and tables stored in the application database are used to display the results in the Streamlit application and save the fetched data in the user’s account.

Disclaimer

This software is provided “AS IS”, without any warranties or guarantees. The authors or copyright holders are not liable for any damages or claims related to its use. By using this software, you agree to these terms.

Quick Links

NextReleases

Last updated 6 months ago

Overview

The application has the following key features:

Universal JSON flattener: Wherever your semi-structured data is sourced from, our flattener will parse it into columnar format tables ready for SQL queries.

Automatic casting to datatypes: Numeric values, text, booleans and timestamp type data are all automatically determined by our autocaster, even in mixed-type or null-holding columns.

Dynamic view building: Build a view once and require no further action when new entries are added to the semi-structured source data, or build one-time static tables if preferred,

Intuitive GUI or ready-to-call procedure: Add, save and load configurations in the accessible Streamlit-powered user interface, or use the available stored procedure to integrate the flattener and auto caster in your custom pipelines.

Data Governance

To make sure the user keeps control over his data, the app provides extensive logs which keeps track off each step the app executes.