-
Notifications
You must be signed in to change notification settings - Fork 86
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Incorrect Compile Code from DBT Power User #1154
Comments
🚀 Here's the PR! #1159💎 Sweep Pro: You have unlimited Sweep issues
Actions
Step 1: 🔎 SearchingHere are the code search results. I'm now analyzing these search results to write the PR. Relevant files (click to expand). Mentioned files will always appear here.vscode-dbt-power-user/dbt_core_integration.py Lines 1 to 825 in 76cd20d
vscode-dbt-power-user/src/dbt_client/dbtCoreIntegration.ts Lines 1 to 1089 in 76cd20d
vscode-dbt-power-user/altimate_packages/altimate/utils.py Lines 1 to 350 in 76cd20d
vscode-dbt-power-user/altimate_packages/sqlglot/generator.py Lines 1 to 2731 in 76cd20d
Step 2: ⌨️ Coding
|
@mdesmet Can you have a look? |
@ashutran : Can you provide us with a sample code that reproduces the issue(s)? I think we don't have the full picture of what you are trying to achieve. |
Expected behavior
While using the Complied DBT preview feature result is not as expected:
{
"code": -1,
"message": "Database Error\n Syntax error: SELECT list must not be empty at [305:1]",
"data": ""Error: Database Error\n Syntax error: SELECT list must not be empty at [305:1]\n\tat DBTCoreProjectIntegration_1. (c:\\Users\\.vscode\\extensions\\innoverio.vscode-dbt-power-user-0.39.12\\dist\\extension.js:18398:127)\n\tat Generator.throw ()\n\tat rejected (c:\\Users\\.vscode\\extensions\\innoverio.vscode-dbt-power-user-0.39.12\\dist\\extension.js:25808:28)""
}
Actual behavior
After compiling the code
Steps To Reproduce
Using poetry shell to activate the poetry virtual env
Using python version 3.11.6
dbt-core 1.6.1
dbt-bigquery 1.6.4
Create any model having Macro for incremental logic using if-else where it'll check if the table exist then if condition else another condition
Log output/Screenshots
No response
Operating System
Windows 10
dbt version
1.6.1
dbt Adapter
dbt-bigquery 1.6.4
dbt Power User version
v0.39.12
Are you willing to submit PR?
The text was updated successfully, but these errors were encountered: