Any idea how to solve the below problem , even when we checking column which is a string like ID in table where one column is JSOS, cloudq is failing with below error:
clouddq[77] ERROR 'JSON' is not a valid DatabaseColumnType
OffRamp_Hmz_hmz_CDE_us_hmz_nonsensitive-dsr_configs-id-PromotionID:
column_id: id
entity_uri:
bigquery://projects/project_id/datasets/dataset/tables/configs
row_filter_id: NONE
rule_ids:
- ID-validity
- ID-Duplicated-Identifiers
- ID-Attribute-Missing
Any idea how to solve the below problem , even when we checking column which is a string like ID in table where one column is JSOS, cloudq is failing with below error:
clouddq[77] ERROR 'JSON' is not a valid DatabaseColumnType
OffRamp_Hmz_hmz_CDE_us_hmz_nonsensitive-dsr_configs-id-PromotionID:
column_id: id
entity_uri:
bigquery://projects/project_id/datasets/dataset/tables/configs
row_filter_id: NONE
rule_ids:
- ID-validity
- ID-Duplicated-Identifiers
- ID-Attribute-Missing