How can I count the last date_time of N dimensions?

Hello there!
I have an solidbox created with Dataprep with the following columns:

  • Name_Rule (String) - Ex.:  "valid_data_max" or "valid_duplicity" ETC. (Multiple quantity)
  • Name_Table (String) - Ex.: sensetive-trusted.Business.process (Multiple quantity)
  • Check_Validation (String) - Ex.: "OK" or "Alert" or "Error"
  • DateTime_Execution (DATETIME) - Ex.: "2023-12-20T09:00:45.208325"

I run a job that execute validation rules for "N" tables, this job can be run multiple times until success on the same day. The question here is: how do I get just the last execution date (regardless of status) for each table+rule of the day?

Basicaly it's a Data Quality Log and I want to show this information with Looker Studio (Table, Time chart, etc). 

1 0 19
0 REPLIES 0
Top Labels in this Space