DataPancake

## Pancake your data™ - Relationally flatten, enrich, and secure complex JSON/XML with zero technical debt—directly inside Snowflake. Plus, build Cortex AI-enhanced data dictionaries and Cortex Analyst semantic models. All generated in minutes instead of months.

<p><br/></p>

**Install the trial version** so you can scan and discover the full schema of your data sources **for Free** to uncover valuable insights into your data.

Experience how DataPancake can accelerate the creation of your semi-structured data pipelines and accelerate your adoption of GenAI to drive real, tangible ROI.

*Large or unique use case? Can't download right now but want a demo? Contact us!*

<p><br/></p>

# **Why DataPancake?**

DataPancake is the only Snowflake Native App designed to take you from raw, complex and deeply nested semi-structured data to fully secure, documented, and GenAI-ready relational Dynamic Tables and Secure Views—with zero technical debt.

<p><br/></p>

**Features**

- Relational Flattening with code-generated "Create Dynamic Table" SQL DDL Statements
- Transformation with custom SQL expressions
- Security Policy Integration with code-generated "Create View" SQL DDL Statements
- Schema Drift Management with continual data and schema monitoring
- Data Dictionary/Synonym/Sample Value Builder with Cortex AI Integration
- Cortex Analyst Semantic Model Generator

<p><br/></p>

**ROI Highlights**

- Significant Reduction of Data Engineering Time
- Increased App/Doc DB Troubleshooting Capability
- Improved Data Quality, Availability, and Security
- Reduction of Data Integration Tool Use
- Faster Time To Value
- GenAI Enablement with Cortex Analyst

<p><br/></p>

# **Who is it for?**

Designed by and for data architects, data engineers, app engineers, data analysts, business analysts, and data scientists, DataPancake handles deeply nested attributes and arrays, polymorphic structures, schema drift, and data governance with precision and scalability, all without external connections or added complexity.

<p><br/></p>

# **Expected Workflow for Schema Discovery (FREE Tier)**

<p><br/></p>

## **#1 - Install DataPancake**

Add the app to your Snowflake account from the Marketplace.

(*This task requires user privileges to install apps inside of Snowflake)*

## #2 - Follow in-app instructions to complete the Admin script builder.

Provide the required information and click the button to generate the script. This will include granting necessary privileges.

## #3 - Execute the setup script inside of a Snowflake worksheet

Then copy the script code into a new worksheet and execute. (This task requires a user role with following privileges: *Snowflake Account Admin, Grant Execute Task, Create Warehouse, and Select Data)*

## #4 - Explore data insights inside the DataPancake app including:

- Number of Polymorphic Attributes
- Number of Arrays
- Number of Objects
- Max Level (the depth of nested arrays)
- Number of Attributes containing Stringified JSON
- Complexity Score

<p><br/></p>

# **Expected Workflow for Pipeline Designer and Code Generation (PAID Tier)**

<p><br/></p>

## **#5 - Update the Data Source**

In the Data Source screen select the desired features, populate required fields, and save your changes.

## **#6 - Design Pipeline**

In the Pipeline Designer screen modify the attribute metadata including**:**

- Source Information
- Type Inference
- Transformation Logic
- Schema Consolidation
- Security Access Policies
- Customize Foreign Keys

## **#7 - Generate and Deploy SQL**

After configuration is complete in Step 6, click the "Generate Data Source SQL" button and retrieve the generated code from the Data Source SQL screen. Deploy code in your environment to instantly create your dynamic tables and views.

## **#8 - Monitor for Schema Drift**

Schedule recurring scans with additional scan settings to detect schema changes and update pipelines automatically with alerting.

## **#9 - Build your data dictionary with Cortex AI Integration**

## **#10 - Configure and generate the semantic model yaml code for Cortex Analyst**

<p><br/></p>

# **Pricing**

<p><br/></p>

## **Free Feature - Schema Discovery**

Unlimited data source (VARIANT columns) scans with summary insights, including attribute counts, nesting depth, and complexity scores.

<p><br/></p>

## **Paid Features**

<p><br/></p>

## Attribute Metadata

$0.50 per attribute per month

## **Security Policy Integration**

$0.75 per attribute per month

## **SQL Code Generation**

$0.90 per attribute per month

## **Data Dictionary Builder**

$0.30 per attribute per month

## **Semantic Model Generation**

$0.50 per attribute per month

<p><br/></p>

## **Enterprise Pricing**

Contact us for custom volume pricing.