# From STTM to Snowflake SQL: Building a Metadata-Driven Data Engineering Copilot

> Source: <https://dev.to/amising6/from-sttm-to-snowflake-sql-building-a-metadata-driven-data-engineering-copilot-n4>
> Published: 2026-06-14 05:33:55+00:00

Most data engineering teams do not struggle because they lack smart people.

They struggle because too much of the delivery process is still repetitive.

A source-to-target mapping document comes in.

Then someone has to manually create:

For one or two tables, this is manageable.

For a real enterprise program with many tables, changing requirements, multiple source systems, and repeated delivery cycles, this becomes a major productivity problem.

That is the problem I am exploring with **Data Engineering Copilot**.

Website: [https://dataengineeringcopilot.com](https://dataengineeringcopilot.com)

The idea is simple:

```
text
Upload STTM
   ↓
Parse metadata
   ↓
Normalize into a canonical metadata model
   ↓
Generate engineering artifacts
```