Query: compute_disk_encryption_status

select
  case
    when disk_encryption_key_type = 'Google managed' then 'Google Managed'
    when disk_encryption_key_type = 'Customer managed' then 'Customer Managed'
    else 'Customer Supplied'
  end as "Encryption Type",
  disk_encryption_key ->> 'kmsKeyName' as "KMS Key"
from
  gcp_compute_disk
where
  id = (split_part($1, '/', 1))::bigint
  and project = split_part($1, '/', 2);