Pricing

Schema Summary

Free!

The Schema Summary tier is the default data sources are set to when added to Pancake. Data sources set to Schema Summary can be scanned an unlimited number of times and you can add as many data sources as you’d like with no limit. Summary analysis for each data source includes:

  • Total Attributes

  • Number of Polymorphic Attributes

  • Number of Arrays

  • Number of Objects

  • Max Level (the depth of nested arrays)

  • Complexity Score

The Complexity Score is a simple formula intended to roughly measure the difficulty of working with a particular data source. This score is intended to give users working with data a better understanding of their data so they can more accurately scope work and determine which data sources are the highest priority for Pancaking.

The Schema Summary tier is free, you only pay for the Snowflake compute used to run the scans. Data sources on this tier can be configured to use a cron job and scanned at regular intervals, and the views created by Pancake can be used to alert users to any changes in a given data source’s schema.

Schema Analysis

$50 per data source per month - billed only in months when a scan is performed

Upgrading a data source gives you access to the detailed schema and all its attribute details, including:

  • Attribute Path

  • Attribute Name

  • Polymorphic Name

  • Attribute Level

  • Attribute Order

  • Data Type

  • Sample Value

  • Array Type (Object or Primitive)

  • For primitive arrays, the data type and the date the attribute was first scanned are included.

The Schema Analysis tier also makes several application views available which can be used to select attribute metadata. This includes version level detail, allowing you to track schema evolution and drift over time.

Dynamic Table Generation

$15 per generated Dynamic Table statement - billed monthly in months when code is generated or updated

When a data source is upgraded to the Dynamic Table Generation (DTG) tier, users are granted the ability to configure additional attribute metadata and generate Snowflake Dynamic Table CREATE statements that produce fully extracted and flattened streams. One dynamic table is generated for the root level, as well as one for each array. The price is the same across all arrays regardless of nested depth.

Note: The Analysis and Dynamic Table Generation tiers will not be selectable unless you have upgraded to the full app though the Pancake listing in the Snowflake Marketplace.

Last updated