Azure Synapse Columnstore index and Varchar(max)

gajanan choure 51 Reputation points
2022-08-12T14:44:09.127+00:00

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.
4,473 questions
{count} votes

Accepted answer
  1. Nandan Hegde 29,906 Reputation points MVP
    2022-08-12T16:05:05.49+00:00

    Eg :

    CREATE TABLE [dbo].[Test]

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

    WITH
    (
    DISTRIBUTION = ROUND_ROBIN,
    CLUSTERED INDEX
    (
    [Id] ASC
    )
    )

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful