Bruv

Your brother in Islam

[yourbrotherinislam]

[yourbrotherinislam]

[yourbrotherinislam]

Searching for objects across Databases in Snowflake

SQL

[yourbrotherinislam]

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.

SQL

[yourbrotherinislam]

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.

SQL

[yourbrotherinislam]

SQL

[yourbrotherinislam]

SQL

[yourbrotherinislam]

SQL

[yourbrotherinislam]

SQL

[yourbrotherinislam]

SQL

[yourbrotherinislam]

Cloud Data Warehouse Comparison

[yourbrotherinislam]

ML-Based Forecasting and Anomaly Detection in Snowflake Cortex

Snowflake Cortex, now in GA, unleashes ML-based forecasting and anomaly detection, empowering SQL users for accurate insights without Python