Data type issue

Question

Data type issue

Vineet S 1,390

unable to load the data even orderdetails varchar(Max) is used to load the data givebn

Statement ID: {0CC82A32-AD18-4AE0-800B-D544DF159D1B} | Query hash: 0x2B2C70F7DFB60D20 | Distributed request ID: {1F621AD9-AFC8-471C-9E1C-EA77DB29B454}. Total size of data scanned is 4 megabytes, total size of data moved is 1 megabytes, total size of data written is 0 megabytes.

Msg 16507, Level 16, State 1, Line 1

used below method to understand it but not working in synapse. . . Please share screenshot

Use execution plans (SHOWPLAN_XML or SHOWPLAN_TEXT) t

Completion time: 2024-08-19T10:52:48.6548918+05:30

column details

'Electrolyser damage on 13 April at Guaiba plant. Rio Grande do Sul, Brazil, 7%, 25M USD EEO XS 15m SIR EEO'

Vinodh247-1375 43,181 Reputation points Volunteer Moderator

2024-08-19T07:13:19.15+00:00

Hi ,

Thanks for reaching out to Microsoft Q&A.

Verify that the column "orderdetails" in your Synapse table is indeed defined as varchar(max). Use CTAS for Initial LoadInstead of directly inserting data, consider using CREATE TABLE AS SELECT (CTAS) for the initial load
Vinodh247-1375 43,181 Reputation points Volunteer Moderator

2024-08-24T23:59:24.6666667+00:00

Just checking if you had a chance to look at this. if so, can you please update it?