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.