Detect & correct Compute snapshots if storage premium

Overview

Migrating compute snapshot storage from premium to standard can lead to significant cost savings. Premium storage is more expensive due to its higher performance and reliability. By moving snapshots that do not require premium performance to standard storage, you can optimize costs without compromising on essential storage needs.

This pipeline allows you to specify a collection of compute snapshots with premium storage and then either send notifications or attempt to perform a predefined corrective action upon the collection.

Getting Started

By default, this trigger is disabled, however it can be configured by setting the below variables

compute_snapshots_if_storage_premium_trigger_enabled should be set to true as the default is false.
compute_snapshots_if_storage_premium_trigger_schedule should be set to your desired running schedule
compute_snapshots_if_storage_premium_default_action should be set to your desired action (i.e. "notify" for notifications or "update_snapshot_sku" to update the snapshot SKU).

Then starting the server:

flowpipe server

or if you've set the variables in a .fpvars file:

flowpipe server --var-file=/path/to/your.fpvars

Pipeline

Correct Compute snapshots with premium storage

Query

select
  concat(
    s.id,
    ' [',
    s.resource_group,
    '/',
    s.subscription_id,
    ']'
  ) as title,
  s.name,
  s.resource_group,
  s.subscription_id,
  s.sp_connection_name as conn
from
  azure_compute_snapshot as s,
  azure_subscription as sub
where
  sub.subscription_id = s.subscription_id
  and s.sku_tier <> 'Standard';

Schedule