In this example - check the data timeliness of
The goal is to set up a timeliness check and verify average timestamp difference between two columns.
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 the 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.