[Bug] Use `show ... starts with` instead of `show ... like` in `_show_object_metadata` - Githubissues

dbt-labs / dbt-snowflake

dbt-snowflake contains all of the code enabling dbt to work with Snowflake

https://getdbt.com

Apache License 2.0

297 stars 177 forks source link

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

Closed aranke closed 4 months ago

aranke commented 4 months ago

Is this a new bug in dbt-snowflake?

[X] I believe this is a new bug in dbt-snowflake
[X] 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

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