Query: storage_bucket_encryption_table

select
  b.name as "Name",
  b.id as "ID",
  case
    when default_kms_key_name is null then 'Google Managed'
    else 'Customer Managed'
  end as "Encryption Type",
  b.default_kms_key_name as "KMS Key",
  b.project as "Project",
  b.location as "Location",
  b.self_link as "Self-Link",
  k.self_link as "KMS Self-Link"
from
  gcp_storage_bucket as b
  left join gcp_kms_key as k on k.self_link like '%' || b.default_kms_key_name
order by
  b.name;