Skip to content
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

Query Results looping for infinite #1249

Closed
1 task
mslamani-ext opened this issue Jun 27, 2024 · 2 comments
Closed
1 task

Query Results looping for infinite #1249

mslamani-ext opened this issue Jun 27, 2024 · 2 comments
Assignees
Labels
bug Something isn't working

Comments

@mslamani-ext
Copy link

Expected behavior

preview the results of run model, by connecting with SSO to snowflake for the first time and keep the session alive for a while.

Actual behavior

hello,
I am using a devcontainer on vscode with python:3.11-slim as docker image for my private project.
vscode version 1.90.2, dbt-core 1.8.0 dbt-snowflake 1.8.1, power user for dbt core v0.41.0
A proxy is configured, sucessfully i installed all the dependencies needed as well as dbt power user vscode extension.
the connection to snowflake is secured by SSO (azure active directory).
when i want to execute a dbt model using the 'query results', it tries to connect to snowflake after about 20 seconds then it is blocked! waiting a response or something else. but when i run dbt debug everything is well.
is there any ideas please about how to debug this or solutions ? thanks

Steps To Reproduce

  • run a model
  • while running it connects with SSO to snowflake then keep the session a live. no need to reconnect for each model execution
  • preview the results in Query Results

Log output/Screenshots

No response

Operating System

linux

dbt version

1.8.0

dbt Adapter

snowflake

dbt Power User version

0.41.0

Are you willing to submit PR?

  • Yes I am willing to submit a PR!
@mslamani-ext mslamani-ext added the bug Something isn't working label Jun 27, 2024
@mdesmet
Copy link
Contributor

mdesmet commented Jul 25, 2024

@AdiGajbhiye : Can you ensure that timeouts are stopping the execution and are displayed as error?

@mdesmet
Copy link
Contributor

mdesmet commented Sep 17, 2024

AFAIK this has been fixed already. Please reopen if not working as expected.

@mdesmet mdesmet closed this as completed Sep 17, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants