ASOF JOINs in Snowflake: 100x Performance on Time-Relative Joins
ASOF JOINs are the most efficient way to relate the timestamp of one table with the timestamp of another table, even when those timestamps don't match exactly.
Feel free to skip