SAP Knowledge Base Article - Public

3539966 - Google BigQuery extraction converts NULLs into 0s

Symptom

Using a GoogleBigQuery connection.

If the data has tables with some columns containing NULLs, the 'NULL' values in attributes are converted to '0'. 

Expected result: NULLs should remain as NULLs and not be converted to 0.

Resolution

Adding the following Extra Connection Argument to the Connection prior to extracting the data resolves this issue:

KeepNullValues=true

Keywords

KBA , BPI-SIG-PI-DS , Data Source (CSV, Connector) , Problem

Product

SAP Signavio Process Intelligence all versions