# Layering

Amfelt generates consistent data layers from a single template: staging, history, and bridge layers with uniform naming conventions. No hand-written SQL.

## Platform · Layering — Data layers, generated automatically.

Pick a template once, and let Amfelt recommend a table type for each table, which decides how it is historized. Staging, history, and bridge layers generated for every table, with current and historical data exposed through views ready for analytics, AI agents, and data products.

Links: [Join the waitlist](/waitlist/)

## Template-driven

Choose snapshot, append, replace, or full SCD Type 2 history, or take Amfelt's recommendation from your data profile. DDL is generated for you.

## Consistently named

One naming convention, applied uniformly: lower-case snake_case names and fixed layer suffixes, under a schema prefix you set per job.

## Always exposed

Bridge views expose current and historical data per object, ready for analytics and AI tools. No ad hoc SQL against the raw layers.

## How it works — From template to production-ready data layers.

Select a template, set a schema prefix, and let Amfelt generate the full layer stack: staging, history, and bridge layers.

## Pick your template. The rest is generated.

Select a historization strategy per table: snapshot, append, replace, or full SCD Type 2 history. Amfelt applies the chosen template across all selected tables, generating the complete staging and history layer DDL without a single line of manual SQL.

Links: [Learn about pipelines](/docs/concepts/pipelines/)

## Consistent naming across every layer.

Amfelt applies one naming convention (lower-case names, fixed layer suffixes, and a schema prefix you can set per job) uniformly across the staging, history, and bridge layers, so your data platform stays consistent and auditable.

Links: [Learn about pipelines](/docs/concepts/pipelines/)

## Current and historical data, always exposed.

Every table gets a staging table, a history table with historization logic, and bridge layers for both current-state and full-history access. Amfelt generates and deploys the DDL. These governed layers are also the foundation for what comes next: semantic definitions emitted in open formats, on the roadmap.

Links: [Explore integrations](/integrations/)

## Build a consistent data platform.

Join the waitlist, or [ask us for a demo](/contact/) to see template-based data layering in action.

Links: [Join the waitlist](/waitlist/)