…ch fixes `NULL` columns issues from the default natural join logic (#786)

* Updated deduplicate macro to use QUALIFY for databricks

* updated changelog

* typo

* Add sample profile for integration tests for Databricks

* Add Databricks to CI

* Add databricks to dev-requirements.txt for bleeding edge

* Add databricks to dev-requirements.txt for bleeding edge

* Remove bleeding edge dbt-databricks from dev-requirements.txt

* Test that input columns are `NULL`-safe

* Test that input columns are `NULL`-safe

* Remove Databricks from CI

* Remove integration tests for `deduplicate` with NULL values

---------

Co-authored-by: Doug Beatty <[email protected]>
Co-authored-by: Doug Beatty <[email protected]>

* GitHub Action to add/remove triage labels as-needed

* Update wording and fix misspelling

* refactor: Use QUALIFY syntax in deduplicate() macro for Redshift

* chore: Update changelog

---------

Co-authored-by: Yauhen Sobaleu <[email protected]>

* Update instructions for the release process

* Remove superscript

* get redshift external tables

redshift external tables are not listed in information_schema.tables  but we can extract the same info from svv_external tables and union the results.
also quote database name as redshift allows dashes which require quotes

* add changelog

* snowflake doesn't accept quotes

---------

Co-authored-by: Anders <[email protected]>

…870)

* add exclude columns to equality test

* add precision option to equality test

* CI fix?

* CI fix 2.0

* Update CHANGELOG.md

* Check for subset of columns (Close #785)

* cast type

* cast type across warehouses

* swap to copiler error, account for ignore columns

* Update CL

* allow for different cased names

* fix CL

* linting

* Rename to exclude_columns

* Fix typo

* Add package-lock.yaml to .gitignore

* Update comments

---------

Co-authored-by: bruno <[email protected]>
Co-authored-by: Joel Labes <[email protected]>
Co-authored-by: gwen windflower <[email protected]>

* Update README.md

Update doc for get_column_values() to specify that the order_by argument must be expressed as an aggregate function.

* Add missing blank space

---------

Co-authored-by: Doug Beatty <[email protected]>

…#876)

* FIX: Failing example for dbt_utils.decuplicate() in README.md

* Cast to a `date`

---------

Co-authored-by: Doug Beatty <[email protected]>

* Disable auto-generation of table of contents (TOC)

* Update comments with the relevant issue number

* update tests: -> data_tests:

* bump require-dbt-version

* undo change to require-dbt-version

* Update README.md

---------

Co-authored-by: Doug Beatty <[email protected]>