`Fill empty cells` step in Preparation generates bad BigQuery SQL

UgoD

Hi,

I'm using Dataiku 10.0.5, Python 3.6 and BigQuery.

I'm trying to fill empty cells of all my columns with 0, but it's not working correctly for some columns.

The first column it's not working with is a boolean column and the others are int (for both database and dataiku types)

When I look the SQL generated, it look like that:

  com.dataiku.dss.shadelib.com.google.cloud.bigquery.BigQueryException: No matching signature for operator = for argument types: INT64, STRING. Supported signature: ANY = ANY 

and the error I get is

CASE 
  WHEN (`my_column` IS NULL OR (`my_column` = '')) THEN CAST('0' AS STRING)
  ELSE `my_column`

for the INT column (replace INT64 by BOOLEAN for the other error)

Seems to be normal, but I don't understand why all my INT64 typed columns don't get this error.

Do you have an way to avoid this error ? Am I doing smtg wrong ?

Best regards

Ugo

---

Operating system used: Windows 10

---

Operating system used: Windows 10