Ensure that the valid and default strategies are up-to-date and accurate per adapter

[dbeatty10]

Contributions

• I have read the contribution docs, and understand what's expected of me.

Link to the page on docs.getdbt.com requiring updates

https://docs.getdbt.com/docs/build/incremental-models#supported-incremental-strategies-by-adapter

and each of the relevant adapter-specific config pages linked below.

What part(s) of the page would you like to see updated?

When #2895 was originally opened on 2023-02-20, I wrote the following:

I don't think they accurately reflect the current defaults and options -- I think there have been some updates since these were first published.

It would be good to determine if this has been resolved since then or if there is still anything outstanding.

Here's where to check the defaults in the base adapter:

• dbt-core
  • default strategy
    • append
  • valid_incremental_strategies
    • append
  • incremental model configs

And here's where to check in all the actual adapters:

• dbt-postgres
  • default strategy
    • delete_insert when there is a unique_key defined and append otherwise
  • valid_incremental_strategies
    • append
    • merge
    • delete+insert
  • incremental model configs
• dbt-redshift
  • default strategy (since not defined, see dbt-postgres that dbt-redshift extends)
    • delete_insert when there is a unique_key defined and append otherwise
  • valid_incremental_strategies
    • append
    • merge
    • delete+insert
  • incremental model configs
• dbt-bigquery
  • default strategy
    • merge
  • valid_incremental_strategies (missing until dbt-bigquery #242) or here
    • merge
    • insert_overwrite
  • incremental model configs
• dbt-spark
  • default strategy
    • append
  • valid_incremental_strategies (missing until dbt-spark #411) or here
    • append
    • merge
    • insert_overwrite
  • incremental model configs
• dbt-databricks
  • default strategy
    • merge
  • valid_incremental_strategies
    • append
    • merge
    • insert_overwrite
    • replace_where
  • incremental model configs
• dbt-snowflake
  • default strategy
    • merge
  • valid_incremental_strategies
    • append
    • merge
    • delete+insert
  • incremental model configs
• dbt-trino
  • default strategy (since not defined, see dbt-core that dbt-trino inherits from)
    • append
  • valid_incremental_strategies
    • append
    • merge
    • delete+insert
  • incremental model configs

Additional information

No response