PackageMaterializationOverrideDeprecation Warning in dbt

[callumwall1994]

Describe the bug
Running dbt test or dbt build with recent versions of dbt-core generates a PackageMaterializationOverrideDeprecation warning. The warning is triggered by elementary's implicit override of the built-in test materialization. This behavior does not currently cause a failure but is flagged as a practice that will be disallowed in future dbt versions.

To Reproduce
Steps to reproduce the behavior:

1. In a dbt project with the elementary package installed, run dbt deps.
2. Run either dbt test or dbt build on any model that has tests.
3. Observe the [WARNING][PackageMaterializationOverrideDeprecation] message in the dbt logs.

Expected behavior
The dbt commands should complete without raising a deprecation warning related to the elementary package, indicating that the test materialization override aligns with current dbt standards.

Screenshots

Environment (please complete the following information):

• Elementary CLI (edr) version: 0.18.1
• Elementary dbt package version: 0.19.1
• dbt version you're using: 1.10.13
• Data warehouse: Snowflake
• Infrastructure details: dbt Cloud

Additional context
This is a forward-looking compatibility issue. The current implementation works as expected, but the warning indicates that it will become a breaking change in a future major release of dbt-core. The goal is to align with dbt's move towards more explicit configurations to prevent conflicts and improve stability.

Would you be willing to contribute a fix for this issue?
I'm reporting this to help track the issue, but I would need guidance to contribute a fix.

[NoyaOffer]

Hey @callumwall1994 !
See a better way to handle the different materializations here, so the warning doesn't appear!