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

[David_Apodaca]

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

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

Resolution

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.

Cause

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

Partitioned tables in BigQuery can only use:

• Ingestion time
• DATE, TIMESTAMP, or DATETIME columns
• Integer range columns

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

Related Content

• Introduction to partitioned tables | docs.cloud.google.com
• Data Types | docs.cloud.google.com

Environment

Stitch