YF Bigquery data source boolean field filtering does not work
Hi guys, we have a BigQuery data source and we have boolean fields in that data source.
When I try to filter on boolean fields in the view, YF gives me Yes or No options, but in the query these options are configured as 0 (zero) and 1 (one). This query returns error from BigQuery because they are integer fields, BigQuery expects true or false. Please see attached screen shots. It is same if I try to filter in the report as well.
I use BigQuery connector 4.1