the call as not supported in vs code extension
- 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
Assessment
This issue has not been assessed yet.