You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The rows_failed column like we see in the image below has the value of 1.
But, when clicked to view the failing rows, we see multiple failing rows.
Solution
Currently, rows_failed might be referring to the number of rows with respect to the entity. Ex: The following airport is not unique in public.airport_data database table which is also true.
But, a more helpful number could be the number of rows in the dataset which are failing. Ex: Out of the 365 rows in the table, all 365 are failing because they all contain the same name in the airport property.
Additional context
For the tests, I prepared the dataset below with the same airport loaded multiple times into the table.
DROPTABLEpublic.airport_data CASCADE;
CREATETABLEIF NOT EXISTS public.airport_data(
uuid UUID PRIMARY KEY,
airport VARCHAR(200) NULL,
airport_iata VARCHAR(200) NULL
);
INSERT INTOpublic.airport_dataVALUES('374fae80-ddd9-348c-996f-208d9aa77a0b','Kempegowda International Airport Bengaluru','BLR');
INSERT INTOpublic.airport_dataVALUES('fc8b28a0-f131-37c8-87f4-4adef44f2634','Kempegowda International Airport Bengaluru','BLR');
INSERT INTOpublic.airport_dataVALUES('60bd060f-3c7d-3563-adea-77848a6120d7','Kempegowda International Airport Bengaluru','BLR');
-- ...-- ...-- For upto 365 times as in the original dataset.
The text was updated successfully, but these errors were encountered:
bkowshik
changed the title
Re-evaluate the logic for rows_failed in the run results page
Re-evaluate rows_failed logic on run results page
Jan 3, 2025
Problem
The
rows_failed
column like we see in the image below has the value of1
.But, when clicked to view the failing rows, we see multiple failing rows.
Solution
Currently,
rows_failed
might be referring to the number of rows with respect to the entity. Ex: The following airport is not unique inpublic.airport_data
database table which is also true.But, a more helpful number could be the number of rows in the dataset which are failing. Ex: Out of the 365 rows in the table, all 365 are failing because they all contain the same name in the airport property.
Additional context
For the tests, I prepared the dataset below with the same airport loaded multiple times into the table.
The text was updated successfully, but these errors were encountered: