data type that cannot participate in a columnstore index Error

DataEng1
Databricks Partner

Hi All

I am trying to insert DF into Synapse table. I need to insert string type columns in DF into Nvarchar fields in Synapse table. I am getting the error ' data type that cannot participate in a columnstore index Error'  

 

Can someone guide on the issue? Appreciate it.