How to cast column from string to bool in dataset from s3 datasource

there is datasource from s3, and, there is a column with bool values, I am trying to create dataset and cast them to integer with boto3 request, but gets import error “field numeric values could not be interpreted” when trying to open dataset

Can anyone help please?

Could you specify how you define inputColumns and DataTransforms in LogicalTableMap?
For S3 all your inputColumns need to be of STRING type, and then you can define a CastColumnTypeOperation to cast it to integer. This should work if your bool values are just 0 or 1, but it won’t work if they are “true” or “false”.

Thank you, Haoran_Sun
Yeah, this is the way I made it