DSS can't read Teradata BLOB column

Antal
Antal Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 91 Neuron
in Setup & Configuration

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

Tagged:
· Share on FacebookShare on Twitter

Best Answer

  • Alexandru
    Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,226 Dataiker
    Answer ✓

    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

    · Share on FacebookShare on Twitter
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…