GoogleCloudPlatform / GoogleCloudPlatform/professional-services-data-validator

Support for Teradata's CLOB data type in row validations

Open
#1,256 3 comments 0 reactions 1 assignee Claimed by @nehanene15 View on GitHub
priority: p3
Dominant language
Python
Stars
524
Forks
171
Avg merge
5d 15h
Merged PRs (30d)
4

Description

Context: row validations
Source: Teradata
Target: BigQuery

Details:
Table in Teradata has a CLOB column which maps to a String column in BigQuery. When attempting row validations on this table, we are seeing the following error:

[Teradata Database] [Errpr 9881] Function 'TransUnicodeToUTF8' called with an invalid number or type of parameters

TransUnicodeToUTF8 cannot be applied to non-VARCHAR data types. Casting to VARCHAR normally happens for columns prior to this step, but this column is already a "string" field in ibis so the casting is not happening.

Adding support for the CLOB data type specifically would ensure the casting to VARCHAR occurs and this error is bypassed.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.