Error when exporting or saving data to Spotfire Library: Could not save data file

Keywords: Tibco Spotfire, Spotfire Analyst, SQL Server, Information Designer 

Details:

In trying to export data table with 1.5M+ rows from analysis file into Library as SBDF file then encountering Spotfire error: "Could not save data file". A more detailed error message in Spotfire Analyst log file could be similar to this one:
 
ERROR 2022-08-10T11:52:56,798-0400 [<username>, #B-404, #20463] ws.library.LibraryService: An exception occurred in method 'saveItem'.
com.spotfire.ws.library.StorageException: Attempting to grow LOB beyond maximum allowed size of 2147483647 bytes., DATABASE_ERROR
   at com.spotfire.ws.library.AbstractPersister.insertContent(AbstractPersister.java:712) ~[spotfire-server.jar:?]
   at com.spotfire.ws.library.LibraryManagerImpl.saveItem(LibraryManagerImpl.java:1957) ~[spotfire-server.jar:?]
   at com.spotfire.ws.library.LibraryManagerImpl.saveItem(LibraryManagerImpl.java:1831) ~[spotfire-server.jar:?]
   at com.spotfire.ws.library.LibraryService.doSave(LibraryService.java:632) ~[spotfire-server.jar:?]
   at com.spotfire.ws.library.LibraryService.saveItem(LibraryService.java:506) ~[spotfire-server.jar:?]
...

This is a system limitation due to Microsoft SQL Server size limit of 2 GB for BLOB storage. This means that the maximum size of any single item stored in the Spotfire library (such as an analysis file) cannot be larger than 2 GB. 
 
Spotfire Server 11.4 System Requirements:
https://docs.tibco.com/pub/spotfire/general/sr/sr/topics/spotfire_server_14_0.html