Trigger: Detect & correct Storage Accounts with secure transfer required disabled

select
  concat(
    sa.id,
    ' [',
    sa.resource_group,
    '/',
    sa.subscription_id,
    ']'
  ) as title,
  sa.id as id,
  sa.name,
  sa.resource_group,
  sa.subscription_id,
  sa._ctx ->> 'connection_name' as conn
from
  azure_storage_account as sa,
  azure_subscription as sub
where
  not enable_https_traffic_only;