From the course: Complete Guide to Google BigQuery for Data and ML Engineers
Join today to access over 24,800 courses taught by industry experts.
Lab assignment: Data quality checks - BigQuery Tutorial
From the course: Complete Guide to Google BigQuery for Data and ML Engineers
Lab assignment: Data quality checks
- Okay, it's lab time. Now for this lab, what I would like you to do is to use the data_quality_queries.sql script. And that script contains a series of multiple queries. I would like you to execute each of the queries in the BigQuery query window. So execute each of the queries and basically apply each of these data quality checks. Okay, and after you've run all of those queries, you should have a good assessment of the data quality for the data set that we're working with in the retail dataset. In this lab, we are going to use SQL for data quality checks. So specifically, we're going to run a series of queries that I have provided in a file called data_quality_queries.sql. So I have again, once again, navigated to the BigQuery console and I'm going to open a SQL query window by just clicking on the plus sign in the upper part of the window. And I'm going to go over to my IDE where I have opened the file data_quality_queries.sql. And what you'll notice in here is there are about, I…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.