professional-services-data-validator: Custom-Query failure for boolean datatype columns

Hi Team,

I have a failure using the DVT tool for random row validation using custom - query method. I have generated the configuration file using below command where the column is_top_placement is boolean datatype.

  data-validation validate custom-query row \
  --source-query-file sq_rm.sql \
  --target-query-file tq_rm.sql \
  -sc rs \
  -tc bq \
  --hash '*' \
  --primary-keys _rest_hash_key,visit_dt,is_top_placement,outcode,app_type \
  -rbs 100 \
  -c cq_rm.yaml

when I trigger the command to run the validation of the above generated YAML file , I run into issues as shown below.

data-validation configs run -c ./cq_rm.yaml

Error: My validation runs fine when I exclude the boolean datatype column from the configuration file.

07/17/2023 02:38:35 PM-INFO: Currently running the validation for yml file: ./cq_rm.yaml
07/17/2023 02:44:03 PM-ERROR: Error (psycopg2.errors.CannotCoerce) cannot cast type boolean to character varying

Please do let me know if more details are required to debug further.

About this issue

  • Original URL
  • State: closed
  • Created a year ago
  • Comments: 21 (4 by maintainers)

Most upvoted comments

why are we sharing email id over github? Can’t this be an issue of GDPR?