https://community.databricks.com/t5/data-engineering/unable-to-write-table-to-synapse-x-has-a-data-type-that-cannot/m-p/52081#M29389 <P>Resolved</P> Wed, 15 Nov 2023 14:57:40 GMT Randy 2023-11-15T14:57:40Z https://community.databricks.com/t5/data-engineering/unable-to-write-table-to-synapse-x-has-a-data-type-that-cannot/m-p/51814#M29269 <P>We have a process that creates a table in Synapse then attempts to write the Data generated in Databricks to it. We are able to create the table no problem but when we go to copy the data we keep getting an error that the column&nbsp;<SPAN>has a data type that cannot participate in a columnstore index. The column type is int not any type of max field. I tried creating the table with no column index store through the create table statement option below but am having no luck.</SPAN></P><P><SPAN>WITH<BR />(<BR />DISTRIBUTION = ROUND_ROBIN,<BR />HEAP<BR />)</SPAN></P><P><SPAN>Does anyone have suggestions as to how to get around this?</SPAN></P> Tue, 14 Nov 2023 19:19:17 GMT https://community.databricks.com/t5/data-engineering/unable-to-write-table-to-synapse-x-has-a-data-type-that-cannot/m-p/51814#M29269 Randy 2023-11-14T19:19:17Z https://community.databricks.com/t5/data-engineering/unable-to-write-table-to-synapse-x-has-a-data-type-that-cannot/m-p/52081#M29389 <P>Resolved</P> Wed, 15 Nov 2023 14:57:40 GMT https://community.databricks.com/t5/data-engineering/unable-to-write-table-to-synapse-x-has-a-data-type-that-cannot/m-p/52081#M29389 Randy 2023-11-15T14:57:40Z