Skip to content

BigQuery types INTEGER and FLOAT should have physicalType INT64 and FLOAT64 #1371

Description

@fantastisch

In datacontract-cli version 1.0.10, I imported a datacontract from a BigQuery table containing INTEGER and FLOAT fields. The datacontract will show physicalType: INTEGER and physicalType: FLOAT respectively.

When running datacontract test, the test fails with the following errors:

🔴 data contract is invalid, found the following errors:
1) col_int64 Check that field col_int64 has physical type INTEGER: expected physical type 'INTEGER' but the column is 'INT64'
2) col_float64 Check that field col_float64 has physical type FLOAT: expected physical type 'FLOAT' but the column is 'FLOAT64'

The solution is to use physicalType: INT64 and physicalType: FLOAT64 respectively.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions