cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to Write Table to Synapse 'x' has a data type that cannot participate in a columnstore index.

Randy
New Contributor III

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

WITH
(
DISTRIBUTION = ROUND_ROBIN,
HEAP
)

Does anyone have suggestions as to how to get around this?

1 ACCEPTED SOLUTION

Accepted Solutions

Randy
New Contributor III
1 REPLY 1

Randy
New Contributor III

Resolved

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!