While you can read and write to blob storage with large objects like varchar(max) now you can't read them via external tables.
E.g. If you define a field with varchar(max) in an external table you can't use it you need to use BCP or SSIS to get it into a physical table that is a heap or supported indexed table.
Msg 102048, Level 16, State 1, Line 56
Columns with large object types are not supported in external tables.40 votes
Sorry for the confusion, there was a regression during deployment in the Large Object support that caused a rollback of the functionality. We are actively working on getting a fix.
- Don't see your idea?