Generate Schema - Gridscript Pipeline

Import and validate structured data into the ETL pipeline, ensuring consistent schema enforcement and high-quality data ingestion for analytics.

Import
Done
data
Upload File
Flatten nested or stringified JSON fields into a normalized, column-based structure to improve data usability, search performance, and compatibility with analytical workflows.
Schema
Idle
Source field
Output field
schema
Sample size
Inspect table data from the context and generate an inferred schema: field names or indices, observed types, nullability, and example values.
Export the flattened dataset to Excel format to support business intelligence reporting, spreadsheet analysis, and data review by non-technical users.
Code
Javascript
Idle
Export the transformed and flattened data to CSV format for efficient data exchange, ETL integration, and interoperability with external analytics systems.