[Yes, You Can] Test SQL

Testing SQL can be awkward. In this talk, we'll cover how to test raw SQL with and without a live database, strategies for managing test environments, testing across SQL dialects, and automating code quality checks locally and in CI (Continuous Integration). You'll leave with concrete patterns and code examples that you can apply to your SQL pipelines. This talk is aimed at (1) Python developers who want to bring software engineering rigor to their SQL workflows and (2) SQL/data engineers looking to level up with Python-based testing tools and automation.