Table: detectify_connector

select
  id,
  name,
  team_token,
  provider,
  created_at,
  updated_at
from
  detectify_connector;

select
  id,
  name,
  last_run ->> 'status' as "last_run_status",
  last_run ->> 'error' as "last_run_error",
  last_run ->> 'completed_at' as "last_run_completed_at"
from
  detectify_connector;

select
  count(*) as connectors,
  provider
from
  detectify_connector
group by
  provider;