ModelFlowData.app
Modern data modeling tool for Bronze/Silver/Gold architectures
Data Layer
BRONZE - Raw Data
SILVER - Cleaned & Validated
GOLD - Business Ready
Modeling Pattern
Data Vault 2.0
Kimball Dimensional
3rd Normal Form
One Big Table
Target Platform
Databricks
Snowflake
BigQuery
Azure Synapse
Amazon Redshift
New Table
Generate SQL
Export Model
Templates
Model Designer
SILVER
Clear
Properties
Table
Column
Relationships
Table Properties
Table Name
Layer
BRONZE
SILVER
GOLD
Schema
Table Type
Hub
Link
Satellite
Dimension
Fact
Bridge
Description
Column Properties
Column Name
Data Type
VARCHAR
INT
BIGINT
DECIMAL
DATE
TIMESTAMP
BOOLEAN
Key Type
None
PK - Primary Key
FK - Foreign Key
BK - Business Key
SK - Surrogate Key
Nullable
Yes
No (NOT NULL)
Default Value
Description
Foreign Key Relationships
No relationships defined
New Relationship
Reference Table
Reference Table
Select table...
Reference Column
Select table first
Save Relationship
SQL Preview
Copy SQL
-- Select a table to generate SQL -- Or click "Generate SQL" for the full model
Legend & Conventions
BRONZE:
Raw, unchanged data
SILVER:
Cleaned, validated data
GOLD:
Business-ready data
PK:
Primary Key (unique identifier)
FK:
Foreign Key (relation to other table)
BK:
Business Key (natural key)
SK:
Surrogate Key (technical key)
Template Gallery
×
Data Vault 2.0
Hub-Link-Satellite model for history and flexibility
Kimball Dimensional
Fact & Dimension tables for reporting
E-commerce
Complete e-commerce data model
Customer 360
Customer data and interactions model
SCD Type 2
Slowly Changing Dimensions Type 2
Financial Reporting
Accounting and financial reporting