dbt-sqlserver
dbt-sqlserver copied to clipboard
Creating indexes in the indexes section of a model config
Implementation of #163
- [x] clustered / nonclustered indexes
- [x] row-store (b-tree) / columnstore indexes
- [x] uniqueness (
UNIQUE
) for row-store indexes (clustered and nonclustered) - [x] nonclustered row-store index may have included columns:
INCLUDE (col1, col2)
- [x] data compression:
ROW
/PAGE
compression for row-store andCOLUMNSTORE
/COLUMNSTORE_ARCHIVE
for columnstore - [x] partitioning (partition schema name and partition column)
Hi @swanderz! It takes 4-5 days to test, but I'm ready to accept suggestions/edits 🚀
Am I correct to think that this PR introduces the possibility to create a unique non-clustered index, which wasn't possible before?
This would be very useful for us!
@NicolasPA Yep, of course:
indexes=[
{'type': 'nonclustered', 'columns': ['customer_id'], 'unique': True}
]
Should be rebased on latest master