Hi,  One of my AWS field name "message_json" is a JSON type variable containing longer than 32767 characters. The follow query runs no error but the returned JSON field string is shorter than actual. So later on when export it as text file to feed libname JSON engine to extract it fails. I run the same Sql in AWS Athena and I can confirmed the field content is cut shorter. can anybody suggest how to keep the JSON field length as-is in the AWS source?   options compress=yes obs=max; Proc sql; connect to redshift as xyz (dsn=d1s2n3 user=sasdummyid password="1234567"); Create Table app_detail as Select * from connection to xyz ( select applicant_id,message_json from <a AWS data table> where applicant_id=xxxxx and as_on_dt='20221231000000' ); disconnect from xyz; quit; ... View more