[Bug]: Changes to the sources don't get applied by default [Snowflake]

[NJarZe]

Overview

Upgraded the package from 2.3.0 to 2.7.0
When I run the dbt run -s dbt_artifacts, the source tables don't include the new fields defined in the source models (e.g. ADAPTER_RESPONSE).

It seems like the incremental materialization is not using on_schema_change. When I look in the dbt_project.yml of the package, the on_schema_change configuration is not there, thus ignoring the new columns.

To fix this, I had to manually change the materialization to table, run dbt run -s dbt_artifacts, then put it back.

How to reproduce

• Install a prior version of the package without new fields in the source tables.
• Generate the source tables
• Upgrade to a newer version of the package which includes new fields
• Try to run dbt run -s dbt_artifacts

Expected behaviour

I would expect that the incremental configuration adds the new columns to the sources.

Screenshots

Environment

Core:
  - installed: 1.8.8
  - latest:    1.8.9 - Update available!

  Your version of dbt-core is out of date!
  You can find instructions for upgrading here:
  https://docs.getdbt.com/docs/installation

Plugins:
  - snowflake: 1.8.4 - Up to date!

Please paste the contents of your packages.yml file here:

packages:
  - package: dbt-labs/codegen
    version: 0.12.1
  - package: brooklyn-data/dbt_artifacts
    version: 2.7.0