If nowadays automated testing tools and practices are quite developed in most programming languages, this is not the case in the SQL world. However, we no longer count the number of bugs and errors that this generates on a daily basis in companies, leading them to consider erroneous analyses in their decision making.
But, unfortunately, most cloud services such as Google BigQuery or Amazon Redshift do not provide any tool allowing developers to test their queries. During this talk, we will present a simple way to unit test your SQL queries on BigQuery, applicable to any data warehouse and SQL dialect, using the following package : https://pypi.org/project/sql-test-kit/
But, unfortunately, most cloud services such as Google BigQuery or Amazon Redshift do not provide any tool allowing developers to test their queries. During this talk, we will present a simple way to unit test your SQL queries on BigQuery, applicable to any data warehouse and SQL dialect, using the following package : https://pypi.org/project/sql-test-kit/