Query Optimization in Snowflake (QOSF)

Advance SQL Analytical Functions

MATCH_RECOGNIZE

ASOF JOIN

Skyline Query

Dynamic PIVOT

Conditional True Event (conditional_true_event)

Conditional Change Event (conditional_change_event)

Ratio to Report (ratio_to_report)

JSON