Sample · Python
etl-python — SQL Server data-warehouse ETL
A Python · pyodbc data-warehouse ETL on SQL Server, built to break the way real migrations do. A Swordfish Sample App for testing the SQL Server→PostgreSQL assessment.
Matt Yonkovit
Requires: SQL Server
Data-warehouse ETL on SQL Server, built to break the way real database migrations break. One of the Swordfish Sample Apps — a fixed, repeatable target for testing Swordfish’s assessment and for following the per-database tutorial.
- Source database: SQL Server
- Stack: Python · pyodbc
- Exercises: MERGE, bulk-load patterns, READ UNCOMMITTED habits, and dynamic SQL
Point Swordfish at the app, run a scan, then grade the findings against the per-app answer key in the repo’s docs/answer-keys/.
Browse sqlserver/etl-python on GitHub → · SQL Server → PostgreSQL tutorial