Attribute Metadata

Overview

Attributes are discovered during scanning and serve as the metadata foundation for generating Dynamic Tables and Views. DataPancake discovers every attribute path at any nesting depth, including:

• All nested structures (any depth)

• Embedded/stringified JSON (recursively parsed)

• Polymorphic variations (same path, different data types)

Key DataPancake Behavior: When an attribute is first discovered, DataPancake proactively creates all 7 polymorphic versions immediately. Only versions matching discovered data types are activated (VERSION_STATUS = 'active'). Inactive versions remain ready for future activation, enabling seamless schema evolution.

---

Documentation

• Attribute Discovery - Discovery process and embedded JSON handling

• Attribute Types - Discovered, Schema, and Virtual attributes

• Polymorphic Versions - The 7 polymorphic variations and proactive creation

• Attribute Metadata Fields - Complete field reference

• Arrays & Nested Structures - Array handling and relationships

• Attribute Lifecycle - Creation, versioning, and schema evolution

• Attributes in Code Generation - How attributes become SQL columns

• Integration & API - Stored procedures and views

---

Quick Reference

Attribute Types:

• 'Discovered' - Found during scanning (ATTRIBUTE_CREATE_TYPE = 'Discover')

• 'Schema' - Created from schema samples (ATTRIBUTE_CREATE_TYPE = 'Schema')

• 'Virtual' - User-created via UI/API

The 7 Polymorphic Versions (created proactively for every attribute):

1. str → {name}_str

2. int → {name}_int

3. float → {name}_float

4. bool → {name}_bool

5. object → {name}_object

6. array_primitive → {name}_array_primitive

7. array_object → {name}_array_object

Key Tables:

• core.datasource_attribute - Core attribute metadata

• core.datasource_attribute_polymorphic_version - Version-specific metadata