dbt-labs / dbt-labs/dbt

the call as not supported in vs code extension

Open
#15,331 0 comments 0 reactions 0 assignees View on GitHub
area:vscode engine:v2 status:triage type:bug
Dominant language
Rust
Stars
13.8k
Forks
2.6k
Avg merge
21h 31m
Merged PRs (30d)
56

Description

### Is this a new bug in the VS Code extension?

- [x] I believe this is a new bug in the VS Code extension, not the dbt Fusion CLI
- [x] I have searched the existing issues and could not find a duplicate

### Current Behavior

### Expected Behavior

seems like vs code extension not support this feature

### Troubleshooting

when I reach dbt support give me below response
Hi Jim,

Thank you for reaching out to dbt Labs Support and for sharing those screenshots. They are really helpful.

The warning you're seeing in the VS Code extension (dbt1070: Syntax error after rendering with introspection... no viable alternative at input 'EXECUTE AS') is a false positive from dbt Fusion's baseline static analyzer. The analyzer attempts to parse your SQL at compile time, but it doesn't yet support Snowflake stored procedure syntax, specifically the EXECUTE AS clause. As your own dbt build output confirms, the model runs successfully in dbt platform and Snowflake without any issues.

To suppress the warning in the VS Code extension, you can add the following config to the affected model:
{{ config(static_analysis='off') }}

Or, if you'd prefer to manage it in your dbt_project.yml and scope it to your helper models:
models:
your_project_name:
helper:
+static_analysis: off
Note: setting static_analysis: off on a model means some VS Code extension features that rely on SQL comprehension (like column-level lineage) won't be available for that model but your builds and runs are completely unaffected.

As noted in the [dbt Fusion static analysis docs](https://docs.getdbt.com/docs/fusion/new-concepts#when-should-i-turn-static-analysis-off):
You should only disable it if the dbt Fusion engine cannot parse SQL that is valid for your database of choice.

This is a very rare occurrence. If you encounter this situation, please [open an issue](https://github.com/dbt-labs/dbt-fusion/issues) with an example of the failing SQL so we can update our parsers.

This looks the same situation here: your SQL is valid Snowflake syntax, but the Fusion parser doesn’t yet support it. We’d encourage you to file a GitHub issue so the engineering team can track adding support for EXECUTE AS.

Please let us know if you have any questions.
Warm Regards,
Grace
Customer Solutions Engineer, APAC

### Steps To Reproduce

when I reach dbt support give me below response
Hi Jim,

Thank you for reaching out to dbt Labs Support and for sharing those screenshots. They are really helpful.

The warning you're seeing in the VS Code extension (dbt1070: Syntax error after rendering with introspection... no viable alternative at input 'EXECUTE AS') is a false positive from dbt Fusion's baseline static analyzer. The analyzer attempts to parse your SQL at compile time, but it doesn't yet support Snowflake stored procedure syntax, specifically the EXECUTE AS clause. As your own dbt build output confirms, the model runs successfully in dbt platform and Snowflake without any issues.

To suppress the warning in the VS Code extension, you can add the following config to the affected model:
{{ config(static_analysis='off') }}

Or, if you'd prefer to manage it in your dbt_project.yml and scope it to your helper models:
models:
your_project_name:
helper:
+static_analysis: off
Note: setting static_analysis: off on a model means some VS Code extension features that rely on SQL comprehension (like column-level lineage) won't be available for that model but your builds and runs are completely unaffected.

As noted in the [dbt Fusion static analysis docs](https://docs.getdbt.com/docs/fusion/new-concepts#when-should-i-turn-static-analysis-off):
You should only disable it if the dbt Fusion engine cannot parse SQL that is valid for your database of choice.

This is a very rare occurrence. If you encounter this situation, please [open an issue](https://github.com/dbt-labs/dbt-fusion/issues) with an example of the failing SQL so we can update our parsers.

This looks the same situation here: your SQL is valid Snowflake syntax, but the Fusion parser doesn’t yet support it. We’d encourage you to file a GitHub issue so the engineering team can track adding support for EXECUTE AS.

Please let us know if you have any questions.
Warm Regards,
Grace
Customer Solutions Engineer, APAC

### Relevant log output

```shell
when I reach dbt support give me below response
Hi Jim,

Thank you for reaching out to dbt Labs Support and for sharing those screenshots. They are really helpful.

The warning you're seeing in the VS Code extension (dbt1070: Syntax error after rendering with introspection... no viable alternative at input 'EXECUTE AS') is a false positive from dbt Fusion's baseline static analyzer. The analyzer attempts to parse your SQL at compile time, but it doesn't yet support Snowflake stored procedure syntax, specifically the EXECUTE AS clause. As your own dbt build output confirms, the model runs successfully in dbt platform and Snowflake without any issues.

To suppress the warning in the VS Code extension, you can add the following config to the affected model:
{{ config(static_analysis='off') }}

Or, if you'd prefer to manage it in your dbt_project.yml and scope it to your helper models:
models:
your_project_name:
helper:
+static_analysis: off
Note: setting static_analysis: off on a model means some VS Code extension features that rely on SQL comprehension (like column-level lineage) won't be available for that model but your builds and runs are completely unaffected.

As noted in the [dbt Fusion static analysis docs](https://docs.getdbt.com/docs/fusion/new-concepts#when-should-i-turn-static-analysis-off):
You should only disable it if the dbt Fusion engine cannot parse SQL that is valid for your database of choice.

This is a very rare occurrence. If you encounter this situation, please [open an issue](https://github.com/dbt-labs/dbt-fusion/issues) with an example of the failing SQL so we can update our parsers.

This looks the same situation here: your SQL is valid Snowflake syntax, but the Fusion parser doesn’t yet support it. We’d encourage you to file a GitHub issue so the engineering team can track adding support for EXECUTE AS.

Please let us know if you have any questions.
Warm Regards,
Grace
Customer Solutions Engineer, APAC
```

### Environment

```markdown
windows vs code extension
```

### Which area of the extension is affected?

other (describe in Additional Context)

### Additional Context

_No response_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.