DSS can't read Teradata BLOB column

Options
Antal
Antal Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 85 Neuron

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:

Best Answer

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

    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

Setup Info
    Tags
      Help me…