Distinct count percent
In this example - check the data of
The data is updated daily. The goal is to set up a uniqueness check and verify how many percent distinct values are in
Download and install Google Cloud CLI. After installing Google Cloud CLI, log in to your GCP account (you can start one for free), by running:
After setting up the GCP account, create a GCP project. That will be the GCP billing project used to run SQL sensors on the public datasets provided by Google.
The examples are using a name of the GCP billing project, received as an environment variable
Set and export this variable before starting DQO shell.
Navigate to the example directory and run the check
After starting the example, run the following commands in the DQO shell:
Now, you can open the browser and navigate to https://cloud.dqo.ai/ and review the sensor results on the dashboards.