The Blackbaud data warehouse provides methods to drop and create columnstore indexes via the BBDW.USP_DROPCOLUMNSTOREINDEX and the BBDW.CREATECOLUMNSTOREINDEX stored procedure. Each accepts a schema and table name. These can be used to drop a columnstore index for a particular table prior to issuing any insert, update or merge statements.
- Be sure to create the columnstore index if dropping it to ensure optimal performance.
- If using the DIM_TEMPLATE.dtsx package this error may be encountered. This package is provided as a template representing best practices for a DIM table package and is not intended to be deployed.
Note: We provide links to third-party websites in an effort to help you resolve your issue. We are not responsible for the information on third-party websites and we cannot assist with implementing resolutions from these websites.