9.26 Release notes: Sep 01, 2025-Sep 04, 2025¶

Filling gaps in time-series data (Preview)¶

You can use the following new features to fill gaps in time-series data sets:

• You can use the RESAMPLE clause within the FROM clause of a SELECT statement to “upsample” rows to a specific time interval and fill in missing rows.

• You can call one of the following interpolation functions to update columns for the generated rows that you resampled. You can also use these functions independently to gap-fill rows in an existing data set:

  • INTERPOLATE_BFILL

  • INTERPOLATE_FFILL

  • INTERPOLATE_LINEAR

For more information, see Filling gaps in time-series data.

Account Usage: New INGRESS_NETWORK_ACCESS_HISTORY view¶

This Account Usage view can be used to query any network access attempts to your Snowflake account within the last year.

For more information, see INGRESS_NETWORK_ACCESS_HISTORY view.

Account Usage: New INTERNAL_STAGE_NETWORK_ACCESS_HISTORY view¶

This Account Usage view can be used to query any network access attempts to your internal stage within the last year.

For more information, see INTERNAL_STAGE_NETWORK_ACCESS_HISTORY view.