Execute dbt SQL not working

[antoine-lefebvre]

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!