Skip to main content
Solved

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

  • Oct 2, 2026 12:26 AM UTC
  • 3 replies
  • 50 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.

Best answer by crystalatsafe

Hi ​@deanr 

It looks like the Microsoft Azure Synapse SQL (Data Warehouse) writer creates tables that do not support the (max) data types: Indexes on dedicated SQL pool tables in Azure Synapse Analytics.

 

While varchar(max) can't be added to the Microsoft Azure Synapse SQL (Data Warehouse) writer, the Microsoft Fabric (Data Warehouse) writer should be able to support it.

 

I have submitted an internal ticket (internal reference: FMEENGINE-100055) for our development team to consider adding varchar(max) as an option for the Microsoft Fabric (Data Warehouse) writer. I will be sure to keep you updated.

View original

3 replies

crystalatsafe
Safer
Forum|alt.badge.img+32
  • Safer
  • Best Answer
  • Oct 19, 2026 9:01 PM UTC

Hi ​@deanr 

It looks like the Microsoft Azure Synapse SQL (Data Warehouse) writer creates tables that do not support the (max) data types: Indexes on dedicated SQL pool tables in Azure Synapse Analytics.

 

While varchar(max) can't be added to the Microsoft Azure Synapse SQL (Data Warehouse) writer, the Microsoft Fabric (Data Warehouse) writer should be able to support it.

 

I have submitted an internal ticket (internal reference: FMEENGINE-100055) for our development team to consider adding varchar(max) as an option for the Microsoft Fabric (Data Warehouse) writer. I will be sure to keep you updated.


deanr
Contributor
Forum|alt.badge.img+3
  • Author
  • Contributor
  • Oct 29, 2026 11:36 PM UTC

Thank you.


deanr
Contributor
Forum|alt.badge.img+3
  • Author
  • Contributor
  • Nov 2, 2026 9:43 PM UTC

New behavior information.  The writer does not provide a varchar(max) data type option, but if a varchar(8000) data type is pointed at a column in a Fabric Warehouse table whose data type is varchar(max), the writer does not truncate the data and does not warn in the log that the data is longer than 8000 characters.