Upgrading dbt-vertica with dbt-core 1.8.5 version

Features:

• Update base adapter references as part of decoupling migration to support dbt core 1.8.3 #131
• Support --empty tests
• Support all types for unit testing in dbt-vertica, expand coverage of safe_cast macro dbt-labs/dbt-core#9798
• Add new workflow for internal patch releases
• Support limiting get_catalog by object name
• Add --empty value to jinja context as flags.EMPTY

Fixes:

• Unit-test check tests
  • test_types.BaseUnitTestingTypes
  • test_case_insensitivity.BaseUnitTestCaseInsensivity
  • test_invalid_input.BaseUnitTestInvalidInput
• Flags.EMPTY check tests
  • BaseTestEmpty
• Support limiting get_catalog check tests
  • BaseChangeRelationTypeValidator
• Warning on unit_test config in dbt_project.yaml file
• Additional tests
  • TestBaseContext
  • BaseIncrementalOnSchemaChangeSetupumns from table(#122).

Upgrading dbt-vertica with dbt-core 1.7.13 version

Fixes:

• Enable connection autocommit parameter(#128).
• Fixed- SQLParse with a high vulnerability(https://github.com/vertica/dbt-vertica/security/dependabot/1).
• Update collect_freshness(#129).
• Incremental strategy, On schema change- Add or remove columns from table(#122).

Upgrading dbt-vertica with dbt-core 1.7.3 version

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

Upgrading dbt-vertica with dbt-core 1.6.0 version

Features:

• Added support for dbt-core version 1.6.0 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

Upgrading dbt-vertica with dbt-core 1.5.0 version

1.5.0

Features:

• Added support for dbt-core version 1.5.0 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

Upgrading dbt-vertica with dbt-core 1.4.4 version

1.4.4

Features:

• Added support for dbt-core version 1.4.0 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.

Upgrading dbt-vertica with dbt-core 1.3.0 version.

1.3.0

Features:

• Added support for dbt-core version 1.3.0 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.

New Contributors

• @Sachin-Thakur made their first contribution in #52

Full Changelog: 1.0.4...v1.3.0

1.0.4

Align merge options with other dbt adapters, closing #25.

1.0.3.1 - Bug Fixes

What's Changed

• fix max args bug by @barloc in #20
• Removed extra verbosity that wasn't needed by @ahedengren in #23

New Contributors

• @barloc made their first contribution in #20

Full Changelog: 1.0.3...1.0.3.1

1.0.3

What's Changed

• Refactor of the Code Base by @ahedengren in #18

Full Changelog: 1.0.2...1.0.3