Loading...Loading chart...
1SELECT 
2    new_datasets,
3    new_tables,
4    rows_added,
5    MAKE_DATE(year, month, 1) as date,
6    SUM(new_datasets) OVER (ORDER BY MAKE_DATE(year, month, 1)) as datasets,
7    SUM(new_tables) OVER (ORDER BY MAKE_DATE(year, month, 1)) as tables,
8    SUM(rows_added) OVER (ORDER BY MAKE_DATE(year, month, 1)) as rows
9FROM "@adlrocha.sandbox.baselight_monthly_stats"
10ORDER BY date;