Query: network_vpc_association

-- Droplets
select
  d.title as "Title",
  'digitalocean_droplet' as "Type",
  d.urn as "URN",
  '/digitalocean_insights.dashboard.droplet_detail?input.droplet_urn=' || d.urn as link
from
  digitalocean_droplet as d,
  digitalocean_vpc as v
where
  v.id = d.vpc_uuid
  and v.urn = $1 -- Databases
union all
select
  d.title as "Title",
  'digitalocean_database' as "Type",
  d.urn as "URN",
  '/digitalocean_insights.dashboard.database_cluster_detail?input.database_cluster_urn=' || d.urn as link
from
  digitalocean_database as d,
  digitalocean_vpc as v
where
  v.id = d.private_network_uuid
  and v.urn = $1 -- Load Balancers
union all
select
  l.title as "Title",
  'digitalocean_load_balancer' as "Type",
  l.urn as "URN",
  null as link
from
  digitalocean_load_balancer as l,
  digitalocean_vpc as v
where
  v.id = l.vpc_uuid
  and v.urn = $1