Query: compute_instance_tags

with jsondata as (
  select
    tags::json as tags
  from
    gcp_compute_instance
  where
    id = (split_part($1, '/', 1))::bigint
    and project = split_part($1, '/', 2)
)
select
  key as "Key",
  value as "Value"
from
  jsondata,
  json_each_text(tags)
order by
  key;