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] snowflake__get_catalog_schemas_where_clause_sql is very slow #1035

Closed
2 tasks done
aranke opened this issue May 13, 2024 · 0 comments · Fixed by #982
Closed
2 tasks done

[Bug] snowflake__get_catalog_schemas_where_clause_sql is very slow #1035

aranke opened this issue May 13, 2024 · 0 comments · Fixed by #982
Labels
triage:product type:bug Something isn't working

Comments

@aranke
Copy link
Member

aranke commented May 13, 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

dbt docs generate for a single model takes 30-90s

Expected Behavior

dbt docs generate for a single model takes 3-4s

Steps To Reproduce

  1. Run dbt docs generate for a single model

Relevant log output

No response

Environment

- OS: MacOS
- Python: 3.12
- dbt-core: 1.8
- dbt-snowflake: 1.8

Additional Context

Ad-hoc internal testing caused query time to drop from 30-90s to 3-4s.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
triage:product type:bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Speedup catalog string comparison by using ilike before equals dbt-labs/dbt-snowflake
1 participant
@aranke