Skip to main content
Question

Microsoft Azure Synapse SQL (Data Warehouse) varchar(max)

  • October 2, 2026
  • 0 replies
  • 4 views
deanr
Contributor
Forum|alt.badge.img+3

Microsoft Azure SQL Database (JDBC MSSQL) User Attributes has a varchar(max)

Microsoft Azure Synapse SQL (Data Warehouse) does not!

I need to write WKT and GeoJson to my Fabric data warehouse and I think I need to use the Microsoft Azure Synapse SQL (Data Warehouse) writer to do that.  Data type varchar(8000) may not be sufficiently long for a line or a polygon for WKT or GeoJson.

Is there something I am missing?  Is a varchar(max) on the roadmap for Microsoft Azure Synapse SQL (Data Warehouse)?

I am using Form 2026.2.

Community Stats

32,933
Posts
124,863
Replies
41,774
Members
Terms & ConditionsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.