When using Veeva Vault VQL with the CozyRoc REST Source, Long Text fields may be limited to 250 characters by default.

To retrieve the full value, use the VQL LONGTEXT() function:

SELECT LONGTEXT(columnname) AS columnname
FROM objectname

For example:

SELECT LONGTEXT(description__c) AS description__c
FROM my_object__c

For more information, see the official Veeva Vault documentation:

Veeva Vault – LONGTEXT()

If needed, the column length can also be adjusted in the Advanced Editor as mentioned here.