How do we Calculate the Running Total or Cumulative Sum in Snowflake

Snowflake - Calculate the Running Total or Cumulative Sum

First, we create the table with the day column and the count column:

select
to_date(start_date) as day,
count(2)
from sessions1
group by to_date(start_date);

After that, we will write the Snowflake CTE(Common Table Expressions) and utilize the window function for keeping the track of the running total or cumulative sum.

select 
to_date(start_date) as day,
count(2)
from sessions2
group by to_date(start_date);

with data as (
  select
    to_date(start_date) as day,
    count(2) as number_of_sessions
from sessions2
group by to_date(start_date)
)
select
   day,
   sum(number_of_sessions) over (order by day asc rows between unbounded preceding and current row)
from data;

Conclusion

By the end of this blog, you can create the Common Table Expressions and use the Windows function for calculating the Running total or Cumulative sum. I hope this information is sufficient.

Snowflake Related Articles

▶  Snowflake vs Redshift
▶  Snowflake vs BigQuery
▶  Snowflake vs Databricks
▶  Snowflake vs Azure
▶  Snowflake vs Hadoop

▶  Snowflake Time Travel

If you have any queries, let us know by commenting below.