data type that cannot participate in a columnstore index Error

DataEng1 — Tue, 12 Sep 2023 17:21:15 GMT

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.

topic data type that cannot participate in a columnstore index Error in Data Engineering

data type that cannot participate in a columnstore index Error