Qlik Stitch BigQuery Loading Error: Partitioning by expressions of type FLOAT64 is not allowed at [3:53]

David_Apodaca — Wed, 03 Dec 2025 06:40:09 GMT

It encounters a loading error when using BigQuery as the destination:

Partitioning by expressions of type FLOAT64 is not allowed at [3:53]

Database integrations:

If your source supports views, create a view and cast the FLOAT64 column to a supported type (for example: INTEGER or TIMESTAMP).
If not, adjust the source schema so the column is not FLOAT64.

SaaS integrations:

If applicable, configure the source to output a compatible type for partitioning.

Partitioning is not required by Stitch to load data into BigQuery. This can be disabled in your destination, but comes with data integrity risks. Reference apply-table-partitioning-clustering(Qlik Stitch Documenation).

As a good rule of thumb, check for null or empty primary key fields in your source tables, as these can cause other loading issues.

This error occurs because BigQuery does not allow partitioning on FLOAT64 columns.

Partitioned tables in BigQuery can only use:

BigQuery documentation explicitly states:
“PARTITION BY expressions cannot include floating point types.”

article Qlik Stitch BigQuery Loading Error: Partitioning by expressions of type FLOAT64 is not allowed at [3:53] in Official Support Articles