Filtering Specific Package Installation in Non-Production Environments in dbt

[megetron3]

I'm currently working with dbt and have a specific requirement where I need to install a package, 'elementary-data/elementary', only in non-production environments. My current packages.yml file looks like this:

packages:
  - package: dbt-labs/dbt_utils
    version: 1.1.1
  - package: elementary-data/elementary
    version: 0.15.2

When I run dbt deps, it installs the 'elementary' package in all environments, which is not what I want. I tried using Jinja templating to conditionally include the 'elementary' package based on the target environment, but I learned that dbt does not support Jinja in the packages.yml file.

Is there a way to filter out the 'elementary' package from the dbt deps command in production environments? Any guidance or suggestions would be greatly appreciated.

Additionally, when the 'elementary' package is installed in the production environment, I receive the following warning:

[WARNING]: Installed package 'elementary' is overriding the built-in
materialization 'test'. Overrides of built-in materializations from installed
packages will be deprecated in future versions of dbt. Please refer to https://d
ocs.getdbt.com/reference/global-configs/legacy-behaviors#require_explicit_packag
e_overrides_for_builtin_materializations for detailed documentation and
suggested workarounds.

This further emphasizes the need to prevent the installation of the 'elementary' package in production environments. I'm looking for a solution that allows me to filter out this package from the dbt deps command in production environments, while still allowing its installation in non-production environments."