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 :
Victor Landeau
Victor has been a Machine Learning Engineer in Paris for more than eight years, bringing value from data science through the application of practices from Software Craftmanship and Lean Startup methodologies.