Copiloting an ETL solution
Proposed session for SQLBits 2026TL; DR
Discover how Github Copilot can help you not just solving a simple problem, but rather write a complete ETL solution while not requiring you writing much of the T-SQL code.
Starting with the very basics of the structure definition, going through the ETL process, delivering data quality checks - we got it all!
This presentation is based on the real-world case, delivered successfully in production.
Session Details
Discover how Github Copilot can help you not just solving a simple problem, but rather write a complete ETL solution while not requiring you writing much of the T-SQL code.
Starting with the very basics of the structure definition, going through the ETL process, delivering data quality checks - we got it all!
This presentation is based on the real-world case, delivered successfully in production.
Starting with the very basics of the structure definition, going through the ETL process, delivering data quality checks - we got it all!
This presentation is based on the real-world case, delivered successfully in production.
3 things you'll get out of this session
To show how ETL development can be accelerated with the help of GitHub Copilot.
To show how to build a testing framework with the help of a same Copilot engine
To warn of some of the limitations and offer some solutions.