Discover this year's submissions to the Dataiku Frontrunner Awards and give kudos to your favorite use cases and success stories!READ MORE

DSS can't read Teradata BLOB column

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 Reply
AlexT
Dataiker
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