Query: pubsub_topic_subscription_details

select
  k.name as "Name",
  topic_name as "Topic Name",
  message_retention_duration as "Message Retention Duration",
  retain_acked_messages as "Retain Acknowledged Messages",
  dead_letter_policy_max_delivery_attempts as "Maximum Number of Delivery Attempts"
from
  gcp_pubsub_topic p,
  gcp_pubsub_subscription k
where
  p.name = k.topic_name
  and p.project = k.project
  and p.self_link = $1;