dbt Fusion 2.0.0-preview.3 breaking tests in CI

[pankajkoti]

Check action: https://github.com/astronomer/astronomer-cosmos/actions/runs/17119471927/job/48556946882?pr=1928#step:7:628

Error traceback

  def run_command_with_subprocess(command: list[str], tmp_dir: Path, env_vars: dict[str, str]) -> str:
        """Run a command in a subprocess, returning the stdout."""
        process = Popen(
            command,
            stdout=PIPE,
            stderr=PIPE,
            cwd=tmp_dir,
            universal_newlines=True,
            env=env_vars,
        )
        stdout, stderr = process.communicate()
        returncode = process.returncode
    
        if 'Run "dbt deps" to install package dependencies' in stdout and command[1] == "ls":
            raise CosmosLoadDbtException(
                "Unable to run dbt ls command due to missing dbt_packages. Set RenderConfig.dbt_deps=True."
            )
    
        if returncode or "Error" in stdout.replace("WarnErrorOptions", ""):
            details = f"stderr: {stderr}\nstdout: {stdout}"
>           raise CosmosLoadDbtException(f"Unable to run {command} due to the error:\n{details}")
E           cosmos.dbt.graph.CosmosLoadDbtException: Unable to run ['/home/runner/.local/bin/dbt', 'ls', '--output', 'json', '--output-keys', 'name', 'unique_id', 'resource_type', 'depends_on', 'original_file_path', 'tags', 'config', 'freshness', '--project-dir', '/tmp/tmp5viijrkb', '--profiles-dir', '/home/runner/work/astronomer-cosmos/astronomer-cosmos/dev/dags/dbt/jaffle_shop', '--profile', 'snowflake_profile', '--target', 'dev'] due to the error:
E           stderr: error: dbt1060: Ignored unexpected key 'materialized'. Try '+materialized' instead. YAML path: 'jaffle_shop.materialized'.
E             --> dbt_project.yml:24:21
E           error: dbt1060: Ignored unexpected key 'materialized'. Try '+materialized' instead. YAML path: 'jaffle_shop.staging.materialized'.
E             --> dbt_project.yml:26:23
E           error: dbt0102: Deprecated test arguments: ["values"] at top-level detected. Please migrate to the new format under the 'arguments' field: https://docs.getdbt.com/reference/deprecations#missingargumentspropertyingenerictestdeprecation.
E             --> models/schema.yml:58:23
E           error: dbt0102: Deprecated test arguments: ["values"] at top-level detected. Please migrate to the new format under the 'arguments' field: https://docs.getdbt.com/reference/deprecations#missingargumentspropertyingenerictestdeprecation.
E             --> models/staging/schema.yml:20:23
E           error: dbt0102: Deprecated test arguments: ["values"] at top-level detected. Please migrate to the new format under the 'arguments' field: https://docs.getdbt.com/reference/deprecations#missingargumentspropertyingenerictestdeprecation.
E             --> models/staging/schema.yml:31:23
E           
E           stdout: dbt-fusion 2.0.0-preview.3
E              Loading ../../home/runner/work/astronomer-cosmos/astronomer-cosmos/dev/dags/dbt/jaffle_shop/profiles.yml
E              Loading packages.yml
E           suggestion: Run 'dbt deps' to see the latest fusion compatible packages. For compatibility errors, try the autofix script: https://github.com/dbt-labs/dbt-autofix
E             Finished 'ls' target 'dev' with 5 errors in 91ms