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
Tool was running fine with no issues but in O/P I see "target_column_name": null & "target_agg_value": null .
I was trying to compare rows for given primary keys & following below syntax.
This is how trying to trigger rows validation between two tables. It was frequently failing with either source/target column names as null . As one of them was null , that results in validation_status "fail" . If agg_value was "null" , that might be BQ issue. But in this case not sure why "source_column_name" was NULL !?
satva
changed the title
Row validation have "target_column_name": null
Row validations frequently fail with either "source/target_column_name" as "null"
Sep 19, 2024
Hi @satva, firstly could you please share a DDL (CREATE TABLE statement) for one of your BQ tables so we can try to replicate your scenario? Thanks!
Other observations: can you verify if there really are equivalent rows between source and target tables considering the filter you're using? Besides that, I don't see right now something that would be wrong with the DVT command itself.
Tool was running fine with no issues but in O/P I see "target_column_name": null & "target_agg_value": null .
I was trying to compare rows for given primary keys & following below syntax.
Please help me understand what I am missing here !?
The text was updated successfully, but these errors were encountered: