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
Uh oh!
There was an error while loading. Please reload this page.
-
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