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)?
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.
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.
