Discover all of the brand-new features and improvements to existing capabilities in the Dataiku 11.3 updateLET'S GO

DSS can't read Teradata BLOB column

Solved!
Antal
Level 3
DSS can't read Teradata BLOB column

I'm having an issue connecting to a table on Teradata Vantage (17) where a data column  is stored in BLOB format. (the column contains image files in base64 encoding)

Dataiku autodetects the column as "string" datatype and all the column's values are read in as NaN. Changing the datatype to Object in the schema definition does nothing.

 

If I query the data directly through Teradata SQL Assistant or SQL studio the data is loaded correctly.

 

Does DSS not support this Teradata datatype?


Operating system used: Windows 10

0 Kudos
1 Solution
AlexT
Dataiker

Hi @Antal ,

DSS does not support BLOB or CBLOB types we have recorded this in our backlog. 

You should be able to explicitly cast to VARCHAR. In a SQL Recipe, read this data into DSS. 

Thanks

 

View solution in original post

0 Kudos
1 Reply
AlexT
Dataiker

Hi @Antal ,

DSS does not support BLOB or CBLOB types we have recorded this in our backlog. 

You should be able to explicitly cast to VARCHAR. In a SQL Recipe, read this data into DSS. 

Thanks

 

0 Kudos