STTM Generation Agent

What it does

An STTM — a Source-to-Target Mapping — is the detailed recipe for every table: which source columns feed it, how each value is transformed, what gets joined, and what gets filtered out. The agent produces this mapping for each table in the design, then delivers it as a clean spreadsheet your analysts can review, comment on, and approve. It's the checkpoint that lets the business confirm the logic before code exists.

How it works

1. Read the designTakes the approved requirements and data model and prepares the context for each table.
2. Map every fieldDocuments the transformation logic, joins, and filters that produce each target column from its sources.
3. Work tables in parallelIndependent tables are mapped at the same time, so larger pipelines are completed faster.
4. Package for reviewDelivers a clean Excel workbook — one your team can read, comment on, and sign off.

What it delivers

• A complete source-to-target mapping for every table in the pipeline
• Clear transformation rules, join conditions, and filters in plain language
• Full column-level lineage — you can see where every value comes from
• A review-ready Excel workbook for business and technical sign-off
• Sensitive data columns flagged automatically so they can be protected
• Supports both standard SQL and Snowpark delivery paths, your choice