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

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.

Read more here: Source link