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?
Copyright 2023 IT Strategists, Inc. All Rights Reserved. Community site to educate and connect Snowflake users, not part of Snowflake Inc.
We share extensive Snowflake Solutions we have synthesized over 6 years of Snowflake Experience and Snowflake Data Superheroes for your Learning Efficiency. Sign up to receive a copy of Frank’s Snowflake Best Practices Blueprint and join 3,000+ others in receiving bi-weekly emails on data, automation and Snowflake optimization from 4x Snowflake Data Superhero.
By Frank Bell and ITS – Snowflake Solutions – Over 3000 subscribers
