我在VS Code的 dbt Power User扩展中遇到了持续的校验错误。扩展把我的 dbt_project.yml 标记为：Runtime Error: outputs not specified in profile 'boond_analytics'。

这使血缘关系图、自动完成和实时验证无法正常工作，尽管dbt Core一切正常。

配置： * dbt版本：1.11.0-b4 * 项目名称：boond_analytics * 配置文件位置：./.dbt_profiles/profiles.yml。 * CLI验证：运行 dbt debug 返回「所有检查均已通过！」并确认Snowflake连接成功。

dbt debug 
20:16:34  Running with dbt=1.11.0-rc3
20:16:34  dbt version: 1.11.0-rc3
20:16:34  python version: 3.10.11
20:16:34  python path: /Users/*****/python3.10
20:16:34  os info: macOS-15.7.4-x86_64-i386-64bit
20:16:35  Using profiles dir at ./.dbt_profiles
20:16:35  Using profiles.yml file at ./.dbt_profiles/profiles.yml
20:16:35  Using dbt_project.yml file at /Users/****/dbt_project.yml
20:16:35  adapter type: snowflake
20:16:35  adapter version: 1.10.3
20:16:35  Configuration:
20:16:35    profiles.yml file [OK found and valid]
20:16:35    dbt_project.yml file [OK found and valid]
20:16:35  Required dependencies:
20:16:35   - git [OK found]

20:16:35  Connection:
20:16:35    account: *****
20:16:35    user: BOOND_DATA_TRANSFORM_DEV
20:16:35    database: BOOND_DEV
20:16:35    warehouse: BOOND_DATA_TRANSFORM_DEV_WH
20:16:35    role: BOOND_DATA_TRANSFORM_DEV_ADMIN
20:16:35    schema: PUBLIC
20:16:35    authenticator: None
20:16:35    oauth_client_id: None
20:16:35    query_tag: dev
20:16:35    client_session_keep_alive: False
20:16:35    host: None
20:16:35    port: None
20:16:35    proxy_host: None
20:16:35    proxy_port: None
20:16:35    protocol: None
20:16:35    connect_retries: 1
20:16:35    connect_timeout: None
20:16:35    retry_on_database_errors: False
20:16:35    retry_all: False
20:16:35    insecure_mode: False
20:16:35    reuse_connections: True
20:16:35    s3_stage_vpce_dns_name: None
20:16:35    platform_detection_timeout_seconds: 0.0
20:16:35  Registered adapter: snowflake=1.10.3
20:16:36    Connection test: [OK connection ok]

20:16:36  All checks passed!

我的本地 profiles.yml 与项目：

.
├── .dbt_profiles/
│   └── profiles.yml    # Extension fails to find outputs here
├── models/
│   ├── staging/
│   ├── intermediate/
│   └── marts/
├── snapshots/
├── dbt_project.yml   # Error: "outputs not specified in profile 'boond_analytics'"
├── packages.yml

boond_analytics:
  target: dev
  outputs:
    dev:
      type: snowflake
      account: "{{ env_var('SNOWFLAKE_ACCOUNT') }}"
      # ... other credentials

编辑： 重新加载VS Code窗口（> Developer: Reload Window）可以修复输出问题，但环境变量仍然找不到。

dbt configuration is invalid : Parsing Error

Env var required but not provided: 'DBT_ENV_SECRET_ACCOUNT_NAME'

即使它们已经在我的环境变量中设置：

echo $DBT_ENV_SECRET_ACCOUNT_NAME
ug*****.**-***-*

这些变量也已在文件夹 ~/.dbt/ 中正确设置

$ cat ~/.dbt/profiles.yml
boond_analytics:
  target: dev
  outputs:
    dev:
      type: snowflake
      account: "ug***.**-***-*"
      user: "<username>"
      role: "<username>_DEV_ADMIN"
      private_key_path: "/User/...."
...

解决方案

我无法直接修复它，但我切换到了nao Ide，现在可以使用我一直在寻找的功能。