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.

Sign up for GitHub

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

Jump to bottom

[Bug] Use show ... starts with instead of show ... like in _show_object_metadata #1102

Closed
2 tasks done
aranke opened this issue Jul 2, 2024 · 0 comments · Fixed by #1107
Closed
2 tasks done

[Bug] Use show ... starts with instead of show ... like in _show_object_metadata #1102

aranke opened this issue Jul 2, 2024 · 0 comments · Fixed by #1107
Assignees
@aranke
Labels
bug Something isn't working

Comments

@aranke
Copy link
Member

aranke commented Jul 2, 2024

Is this a new bug in dbt-snowflake?

  • I believe this is a new bug in dbt-snowflake
  • I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

show objects queries can get slow and take up to 3s

Expected Behavior

show objects queries take optimal 300ms

Steps To Reproduce

  1. Run many individual show objects queries in sequence

Relevant log output

No response

Environment

No response

Additional Context

Solution from Snowflake: https://dbt-labs.slack.com/archives/C04R0T4H8ES/p1719874443806149?thread_ts=1719586466.620999&cid=C04R0T4H8ES
@aranke aranke added bug Something isn't working triage labels Jul 2, 2024
@aranke aranke self-assigned this Jul 2, 2024
@aranke aranke removed the triage label Jul 2, 2024
aranke added a commit that referenced this issue Jul 5, 2024
@aranke
Fix #1102: Use show ... starts with instead of show ... like in _show…
8c29609 
…_object_metadata
@aranke aranke mentioned this issue Jul 5, 2024
Merged
4 tasks
mikealfare added a commit that referenced this issue Jul 11, 2024
@aranke @mikealfare
Fix #1102: Use show ... starts with instead of show ... like in `…
b2ce704 
…_show_object_metadata` (#1107)

* Fix #1102: Use show ... starts with instead of show ... like in _show_object_metadata

* fix test imports

---------

Co-authored-by: Mike Alfare <13974384+mikealfare@users.noreply.github.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@aranke aranke

Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
1 participant
@aranke