Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

FrEgne

Change VARCHAR(8000) to VARCHAR(MAX) in Auto Create Mode for copy data activities

Submitted by on ‎04-06-2026 06:29 AM

For especially generic pipeline development it is often a necessity to be able to store string data larger than 8000 chars/bytes. Using the Auto Create mode of a copy data activity creates those columns with the varchar(8000) type which then leads to an error while loading if the data inside of the column in the source exceeds the 8000 bytes/chars. The support for varchar(MAX) is out for quite a long time, yet its still not implemented in this activity.

We highly demand this feature to be able to further develop generic solutions to optimize our way of working with Fabric and we encourage the development team to implement this feature because implementation is quick. Its probably just the underlying CREATE statement being generated and run that needs a small change.

 

Status: New
See more ideas labeled with:
Comment