Bruv

Searching for objects across Databases in Snowflake

CONDITIONAL_TRUE_EVENT is a powerful, yet underutilized Window Function in Snowflake. CONDITIONAL_TRUE_EVENT let’s you cumulatively count the occurrences of a TRUE event in a WINDOW.

Snowflake’s INFORMATION_SCHEMA provides a metadata access to all the objects in a Database. You can look for TABLES, SCHEMAs etc. However the INFORMATION_SCHEMA is at the Database level i.e. you can only search at the Database level. What if you need to find objects across all the databases in your Snowflake? Snowflake provides an easy way to achieve this using the system$ngram_search Function in Snowflake.