DBT SQLSERVER Index creation issue

Completed with 1 error and 0 warnings:
13:30:46 (‘42000’, ‘[42000] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]CREATE INDEX statement failed because a columnstore index cannot be created in this edition of SQL Server. See Books Online for more details on feature support in different SQL Server editions. (35315) (SQLMoreResults)’)

Facing the above error, which dbt -SQL Server model creation. Source table is have indexes. But, i’m not need the indexes. i have to create the table (Model) with out indexes.
Any one provide the idea?

{{ config(materialized=‘table’) }}

with source_data as (

select 1 as id
union all
select null as id


select *
from source_data

It’s a MSSQL specific issue, try to update your config settings:
{{ config({'materialized':'table', 'as_columnstore':false}) }}
Helped me to resolve the same issue.

You might find this documentation page useful: