Query: compute_disk_encryption_table

select
  d.name as "Name",
  d.id::text as "ID",
  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",
  d.disk_encryption_key ->> 'kmsKeyName' as "KMS Key",
  p.name as "Project",
  p.project_id as "Project ID",
  d.location as "Location",
  d.self_link as "Self-Link"
from
  gcp_compute_disk as d,
  gcp_project as p
where
  p.project_id = d.project
order by
  d.name;