Yes, it does support correlated subqueries but they have to be correlated scalar subqueries in WHERE clauses.
You can also find more information about subqueries in Snowflake at Can you perform nested queries in snowflake?
Gisele Casillas Edited answer January 22, 2022