AnsweredAssumed Answered

How long is the description field in CanvasData?

Question asked by David Daza on Jul 23, 2019
Latest reply on Jul 23, 2019 by Robert Carroll

We are using CanvasData and we are uploading our files to the DWH. We'd struggled with fields like "description" with a lot of text, one of the suggestions that we got is to use the CLOB type in our Oracle DB, but we noticed that processing time increased from 1 minute to 6 minutes after started using CLOB type. We woul like to limit the description field with a varchar type with 256 characters. Does anyone knows how long is the description field in CanvasData?

 

I was trying to read the Canvas Schema from this url https://portal.inshosteddata.com/api/schema/latest but it wasn't easy to identify the description field based on specific CanvasData file.

 

canvasdata dwh clob

Outcomes