SELECTSELECT

Announcement

Hourly granularity now available in all timeseries plots

By SELECT Team

This page is also available in Português, Deutsch, Español, Italiano, Français, and 日本語.

Hourly granularity now available in all timeseries plots

Users can now view data down to the hour in all timeseries plots available in SELECT.

Niall WoodwardCo-founder & CTO of SELECT

Data warehouse workloads often follow specific patterns based on the time of day or week. A surge of queries every Monday morning at 9AM, decreased usage on weekends, or a spike over a few hours as an expensive backfill is run. To help Snowflake users better understand their usage, we've added the ability for all timeseries plots to be viewed at the hourly level.

SELECT timeseries granularity dropdown selector

By analyzing trends at a more granular level, users can more easily understand their usage and identify optimization opportunities. Take this reporting warehouse as an example. There's a fairly consistent pattern of the warehosue utilization dropping below 10% every night, presenting a great opportunity for scheduled downsizing.

SELECT now supports hourly granularity in all timeseries plots