Extract
Flatten
Polymorph
Relate
Extract
Flatten
Polymorph
Relate
Automate your document data pipelines with Pancake
Pancake automates parsing hierarchical document data and generating SQL, enabling organizations to efficiently map and flatten complex data structures into truly relational data.
01
Scan & Discover
Pancake scans a source to produce a consolidated document representing the full schema of all documents in that source. Metadata is then created for each unique attribute – including polymorphic ones.
02
Configure
Users configure foreign key attributes, aliases for nested arrays, and source-to-destination type mapping.
03
Generate
Pancake generates specific source code or destination-specific SQL to extract and flatten your hierarchical data into relational tables or streams.
04
Monitor
Source data is monitored for schema changes, notifying you when a change is made. With version history you can see how the shape of your schema changes over time.