Dbt-vertica

Features:
- New capability support structure for adapters
- Metadata freshness checks
- Catalog fetch performance improvements
- Behavior of dbt show's --limit flag
- Migrate date_spine() Macro from dbt-utils to Core
- Data Spine Tests
- Storing Test Failures as View
- Additional Tests

Fixes:

- Metadata freshness checks Tests
- TestGetLastRelationModified
- TestListRelationsWithoutCachingSingle
- TestListRelationsWithoutCachingFull
- Behavior of dbt show's --limit flag Tests
- BaseShowSqlHeader
- BaseShowLimit
- Data Spine Tests
- TestDateSpine
- TestGenerateSeries
- TestGetIntervalsBetween
- TestGetPowersOfTwo
- Storing Test Failures as View
- TestStoreTestFailuresAsInteractions
- TestStoreTestFailuresAsProjectLevelOff
- TestStoreTestFailuresAsProjectLevelView
- TestStoreTestFailuresAsGeneric
- TestStoreTestFailuresAsProjectLevelEphemeral
- TestStoreTestFailuresAsExceptions
- Additional Tests
- TestCloneSameTargetAndState
- SeedUniqueDelimiterTestBase
- TestSeedWithWrongDelimiter
- TestSeedWithEmptyDelimiter

Features:
- Added support for [`dbt-core version 1.6.0`](https://github.com/dbt-labs/dbt-core/discussions/7958) according to DBT guidelines.
- Added support of oAuth authentication.
- New `clone` command.
- Droped support for Python 3.7.

Fixes:
- Ensure support for revamped `dbt debug`.
- New limit arg for `adapter.execute()`
- Configuring composite unique key for incremental merge or insert+update strategy
- Added new functional tests and parameterize them by overriding fixtures:
- TestIncrementalConstraintsRollback
- TestTableContractSqlHeader
- TestIncrementalContractSqlHeader
- TestModelConstraintsRuntimeEnforcement
- TestConstraintQuotedColumn
- TestEquals
- TestMixedNullCompare
- TestNullCompare
- TestVerticaCloneNotPossible
- TestValidateSqlMethod

Features:
- Added support for [`dbt-core version 1.5.0`](https://github.com/dbt-labs/dbt-core/discussions/7213) according to DBT guidelines.
- Support for Python 3.11.
Fixes:
- Added support for `constraints` data structure.
- Implemented `data_type_code_to_name` to convert Python connector return types to strings.
- In both `create_table_as` and `create_view_as` macros, raised an explicit warning if a model is configured with an enforced contract
- Added new functional tests and parameterize them by overriding fixtures:
- TestTableConstraintsColumnsEqual
- TestViewConstraintsColumnsEqual
- TestIncrementalConstraintsColumnsEqual
- TestTableConstraintsRuntimeDdlEnforcement
- TestIncrementalConstraintsRuntimeDdlEnforcement
- TestModelConstraintsRuntimeEnforcement

Features:
- Added support for [`dbt-core version 1.4.0`](https://github.com/dbt-labs/dbt-core/discussions/6624) according to DBT guidelines.
- Support for Python 3.11.
Fixes:
- Merge strategy config parameter `merge_update_columns` is now working as intended.
- The incremental flag `--full-refresh` is now working as intended.

Features:
- Added support for [`dbt-core version 1.3.0`](https://github.com/dbt-labs/dbt-core/discussions/6011) and migrated testing framework to new testing framework according to DBT guidelines.
- Support for incremental model strategy ‘Append’.
- Support for incremental model strategy ‘insert_overwrite’.
- Support for multiple optimization parameters for table materialization:
- order_by
- segmented_by_string
- segmented_by_all_nodes
- no_segmentation
- ksafe
- partition_by_string
- partition_by_group_by_string
- partition_by_active_count
- Support for enabling privileges inheritance for tables/views using INCLUDE SCHEMA PRIVILEGES by default in model materialization. If not required, can be disabled using EXCLUDE in the Vertica Server.
- Defined profile_template which helps user to configure profile while creating the project.
- Support for Python 3.10.
Fixes:
- Incremental materialization refactoring and cleanup.
- Updates to correctly handle errors for multi-statement queries.
Breaking Changes
Change description:
- Refactored `merge_columns` config parameter to `unique_key`.
- Support for the `merge_update_columns` to only merge the columns specified.
Impact:
- For the incremental model strategy ‘delete+insert’ and ‘merge’, `unique_key` is now a required parameter and it fails if not provided.
- Existing applications using config parameter `merge_columns` will give an error because `merge_columns` as been removed.
Workaround/Solution:
- When using the incremental model strategy ‘delete+insert’ and ‘merge’ pass the required parameter `unique_key` instead of `merge_columns` in config and `merge_update_columns` is used to only merge the columns specified.

- Refactored the adapter to model after dbt's global_project macros
- Unimplemented functions should throw an exception that it's not implemented. If you stumble across this, please open an Issue or PR so we can investigate.