Execute dbt SQL not working

antoine-lefebvre commented 1 day ago

Expected behavior

When I click on the execute dbt SQL button, the results are displayed

Actual behavior

When I click on the execute dbt SQL button I get the following error:

Database Error Syntax error: Unexpected keyword LIMIT at [4:3]

Followed by:

{
  "code": -1,
  "message": "Database Error\n  Syntax error: Unexpected keyword LIMIT at [4:3]",
  "data": "\"Error: Database Error\\n  Syntax error: Unexpected keyword LIMIT at [4:3]\\n\\tat DBTCoreProjectIntegration_1.<anonymous> (/home/vscode/.vscode-server/extensions/innoverio.vscode-dbt-power-user-0.39.20/dist/extension.js:18410:127)\\n\\tat Generator.throw (<anonymous>)\\n\\tat rejected (/home/vscode/.vscode-server/extensions/innoverio.vscode-dbt-power-user-0.39.20/dist/extension.js:26056:28)\""
}

and I can see in my BigQuery query history that were 2 queries sent with just:

LIMIT 500

and nothing else in the query

Steps To Reproduce

Open a dbt model
Click on the execute dbt SQL button
See the error

Log output/Screenshots

Operating System

macos version 14.6.1

dbt version

1.8.6

dbt Adapter

dbt-bigquery

dbt Power User version

v0.45.0

Are you willing to submit PR?

[ ] Yes I am willing to submit a PR!

anandgupta42 commented 1 day ago

@antoine-lefebvre, does this happen for all queries or specific ones?

yoppysource commented 21 hours ago

Same here, it works well but when I add limit keyword it falls to fail. I am using dbt-bigquery as well!

AltimateAI / vscode-dbt-power-user