Common table expressions (CTEs) are a great way to break up complex queries. Snowflake also supports this functionality. Here's a simple query to illustrate how to write a CTE:
with free_users as (
where plan = 'free'
inner join free_users on free_users.id = user_sessions.user_id
order by free_users.id;
You can find more complex examples of using CTE's in How to Avoid Gaps in Data in Snowflake and in Calculating Cumulative Sums in Snowflake.
Spread the word