Azure Synapse Columnstore index and Varchar(max)

gajanan choure 41 Reputation points

Hi ,
I am Creating table in Synapse dedicated sql pool with
Field of varchar(max) and it is taking clusterd columnstore index by default and throwing error as Varchar max filed can not be added in columnstore index.

How should i use varchar (max) while creating table with other index other than columnstore index.

Is there any way we can use varchar (max ) and We can disable Columnstore index or we can use other options.
Note - We have Column in source which is having more than 8000 char so we need varchar(max)

Thank you.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
2,876 questions
{count} votes

Accepted answer
  1. Nandan Hegde 22,211 Reputation points

    Eg :

    CREATE TABLE [dbo].[Test]

    [Id] [INT] NOT NULL
    ,[Skills] VARCHAR NULL

    [Id] ASC

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful