Query: vcn_subnet_overview

select
  display_name as "Name",
  time_created as "Time Created",
  subnet_domain_name as "Subnet Domain Name",
  region as "Region",
  id as "OCID",
  compartment_id as "Compartment ID"
from
  oci_core_subnet
where
  id = $1 and lifecycle_state <> 'TERMINATED';