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