snowflake-sqlalchemy icon indicating copy to clipboard operation
snowflake-sqlalchemy copied to clipboard

SNOW-751046: get_columns is very slow in schemas with many tables

Open thegreymatter opened this issue 2 years ago • 1 comments

Please answer these questions before submitting your issue. Thanks!

when calling get_column for a table, the rationale behind it was an "optimization" that was implemented to load eagerly and cache all columns in the schema when first calling get_column for any table in the schema. while it is a good optimization for smaller schemas, it slows down the experience considerably in larger schemas.

it woudl be great if at the least I will have the ability to override this default behavior.

thegreymatter avatar Feb 28 '23 17:02 thegreymatter

solution could possibly relate to https://github.com/snowflakedb/snowflake-sqlalchemy/issues/406

sfc-gh-dszmolka avatar Mar 18 '24 10:03 sfc-gh-dszmolka