9.26 Release notes: Preview¶

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

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.

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.

Sensitive data classification: Classifying views automatically¶

You can now configure sensitive data classification so the views in a database are automatically classified at regular intervals. Previously, only tables could be classified automatically.

Sensitive data classification: Excluding objects from automatic classification (Preview)¶

By default, Snowflake automatically classifies all sensitive data in a database that has a classification profile set on it. You can now configure Snowflake to exclude schemas, tables, or columns from automatic classification so that they’re skipped during the classification process.