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 = $1;