STTM Analyzer Agent
STTM Analyzer Agent: Automate SQL generation from STTM files for faster data engineering.
Publisher
Accenture
Product Details
This agent parses STTM (source-to-target mapping) files and generates the transformation SQL needed to move data from source to target, storing the output in Cloud Storage. It analyzes the STTM CSV, applies contextual transformation logic such as joins, filters, and derived columns, builds commented SQL, validates it against the schema, and organizes the results by target table.
The agent replaces a manual, error-prone mapping process by generating BigQuery SQL scripts automatically, handling complex logic while keeping output accurate. Built for ETL developers and data migration projects, it eliminates manual SQL coding for mapping rules and improves developer productivity by 10x. It uses Vertex AI, Pandas, Cloud Storage, BigQuery, and FastAPI.
Key Use Cases
Automated Data Migration SQL Generation
Converts source-to-target mapping spreadsheets into production-ready BigQuery SQL pipelines, cutting manual ETL development effort.
Target Schema Validation & Mapping Governance
Validates derived transformation rules, joins, and filters against target warehouse schemas before deployment to eliminate runtime SQL errors.
Explore detailed deployment path
Requires Gemini. Access integration prerequisites, specialized agent configuration guides, and implementation documentation.