dbt-msft / dbt-sqlserver

dbt adapter for SQL Server and Azure SQL
MIT License
210 stars 98 forks source link

as_columnstore does not seem to work for views #437

Open alkio-netlight opened 1 year ago

alkio-netlight commented 1 year ago

I have

{{
    config(
        as_columnstore=true
        )
}}

for my model and it is materialized as a view. However, this seems to have no effect as if I run this model against a database that does not support columnstores, the command still succeeds.

dsjoho commented 1 year ago

What do you mean this should do? Do you want to create an indexed view? If so I would arrange it with a post-hook. If not, then I'm confused as columnstore would be for tables/storage of the data which won't happen for a view.