<@U088WCP3B4P> is there any known issue with the d...
# ask-elementary-ai
m
@kapa.ai is there any known issue with the dbt vs code extension ?
k
A message from kapa.ai
Yes, there are known issues reported with the dbt VS Code extension (specifically, the "dbt Power User" extension) when used alongside Elementary. Users have experienced errors and unexpected behavior, such as new terminals opening and error messages appearing after installing new packages. In some cases, disabling the dbt Power User extension resolved these issues. For example, one user found that disabling the extension allowed them to proceed with testing Elementary, and another reported that the extension's interaction with package installation could cause problems, which were resolved by turning it off during package installation or troubleshooting Elementary setup. This suggests that the extension can interfere with dbt or Elementary workflows in certain environments, especially when installing or updating packages or running commands from within VS Code terminals. If you encounter issues, try disabling the extension to see if it resolves the problem [Slack thread: dbt Power User extension issues](https://slack.com/archives/C02CTC89LAX/p1657884938163639). Additionally, another user reported that disabling the dbt Power User extension helped resolve issues with running Elementary CLI commands and generating reports, indicating that the extension can sometimes interfere with Elementary's operation in VS Code [Slack thread: CLI and extension conflict](https://slack.com/archives/C02CTC89LAX/p1680035534817339). In summary, if you experience problems with Elementary in VS Code, consider temporarily disabling the dbt Power User extension as a troubleshooting step.
m
I have this one:
Copy code
warning: (will error post beta) dbt1060: While parsing config: Ignored unexpected key `"meta"`. YAML path: `meta`.
  --> dbt_packages/elementary/models/run_results.yml:139:5
error: dbt1501: Failed to render SQL No method named 'to_dict' for 'Map'
(in dbt_packages/elementary/macros/edr/system/hooks/on_run_end.sql:25)
(in dbt_packages/elementary/macros/edr/dbt_artifacts/upload_dbt_invocation.sql:22)
(in dbt_packages/elementary/macros/edr/dbt_artifacts/upload_dbt_invocation.sql:131)
  --> dbt_packages/elementary/macros/edr/dbt_artifacts/upload_dbt_invocation.sql:131:1
warning: dbt1000: Warnings marked (will error post beta) will turn into errors before leaving beta. Please fix them.

Output: suggestion: Try the autofix script: <https://github.com/dbt-labs/dbt-autofix>
  Finished 'show'  with 1 error and 1 warning in 2s 24ms 683us
@kapa.ai
k
Sorry @Mo, I'm not sure what you mean. Please try again. 👋
m
@kapa.ai I have this error:
Copy code
warning: (will error post beta) dbt1060: While parsing config: Ignored unexpected key `"meta"`. YAML path: `meta`.
  --> dbt_packages/elementary/models/run_results.yml:139:5
error: dbt1501: Failed to render SQL No method named 'to_dict' for 'Map'
(in dbt_packages/elementary/macros/edr/system/hooks/on_run_end.sql:25)
(in dbt_packages/elementary/macros/edr/dbt_artifacts/upload_dbt_invocation.sql:22)
(in dbt_packages/elementary/macros/edr/dbt_artifacts/upload_dbt_invocation.sql:131)
  --> dbt_packages/elementary/macros/edr/dbt_artifacts/upload_dbt_invocation.sql:131:1
warning: dbt1000: Warnings marked (will error post beta) will turn into errors before leaving beta. Please fix them.

Output: suggestion: Try the autofix script: <https://github.com/dbt-labs/dbt-autofix>
  Finished 'show'  with 1 error and 1 warning in 2s 24ms 683us
k
A message from kapa.ai
The error and warning messages you are seeing are related to changes in dbt's configuration parsing and Jinja rendering, which are affecting the Elementary package: 1. Warning about "meta" key:
Copy code
warning: (will error post beta) dbt1060: While parsing config: Ignored unexpected key `"meta"`. YAML path: `meta`.
This warning means that dbt is now stricter about unexpected keys in YAML config files. The "meta" key in your
run_results.yml
is being ignored and will cause an error in future dbt versions. This is a warning for now, but you should remove or update the "meta" key in your YAML to avoid future issues. 2. Error: No method named 'to_dict' for 'Map':
Copy code
error: dbt1501: Failed to render SQL No method named 'to_dict' for 'Map'    (in dbt_packages/elementary/macros/edr/system/hooks/on_run_end.sql:25)    (in dbt_packages/elementary/macros/edr/dbt_artifacts/upload_dbt_invocation.sql:22)    (in dbt_packages/elementary/macros/edr/dbt_artifacts/upload_dbt_invocation.sql:131)
This error is due to the use of the
to_dict
method on a Jinja
Map
object, which is not supported in recent dbt versions. This is a known issue that has been reported when using newer dbt versions with certain releases of Elementary. The Elementary team has addressed similar issues in past releases by updating their macros to be compatible with dbt's changes. What you should do: - Upgrade Elementary: Make sure you are using the latest version of the Elementary dbt package. The team regularly releases updates to maintain compatibility with new dbt versions. After upgrading, run:
Copy code
dbt deps   dbt run --select elementary
This process has resolved similar macro compatibility issues for other users after upgrading Elementary and running the above commands [Github Issue: dbt compile failed after installing elementary-data](https://github.com/elementary-data/elementary/issues/1427). - Check for breaking changes in dbt: If you are using a beta or very recent version of dbt, some features or methods (like
to_dict
) may have been removed or changed. If upgrading Elementary does not resolve the issue, you may need to temporarily use an earlier dbt version that is known to be compatible with your Elementary package. - Remove or update the "meta" key: Edit your
run_results.yml
to remove or properly configure the "meta" key as per dbt's latest documentation, since it will soon cause errors. If after upgrading you still encounter the error, please check the Elementary release notes or Slack community for any hotfixes or workarounds for your specific dbt version. If you need more targeted help, please provide your dbt and Elementary versions, as compatibility is often the root cause of these issues.