How to change the default index created with the table materialziation in SQL server #2291
niluparupasinghe
announced in
Archive
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
When I use table materialization in SQL server, it always create an index of the form "{{table_name}}_cci". For example if my table is "FactCustomers" then the index is created named as "FactCustomers_cci". Is there a way to edit this so that I can use my own type (clustered, non clustered, etc) or is there a way to delete this while running "dbt run", so that I can use a macro to create my own index. Currently I am using a macro to first delete this from the database and create my own index. But I need a more simple way if possible.
Beta Was this translation helpful? Give feedback.
All reactions