initiatives

Schema reference for the initiatives SQL view — one row per initiative grouping policies around a shared goal or compliance requirement.

initiatives

The initiatives view provides information about initiatives in Lunar. Initiatives are collections of policies organized around a specific goal or purpose.

Schema

Column	Type	Description
id	TEXT	The identifier for the initiative
description	TEXT	A description of the initiative
owner	TEXT	The owner of the initiative
manifest_version	TEXT	The version of the manifest that defines this initiative
created_at	TIMESTAMP	When the initiative was created

Notes

• Initiatives are organized collections of policies designed around a specific goal or compliance requirement

• Each initiative can contain multiple policies and may span different components

Usage examples

List all initiatives in the system:

SELECT *
FROM initiatives
ORDER BY id;

Find initiatives owned by a specific person:

SELECT *
FROM initiatives
WHERE owner = '[e-mail]';

Get a list of initiatives and the number of policies within each:

SELECT 
  i.id AS initiative_id,
  i.description,
  COUNT(p.id) AS policy_count
FROM initiatives i
LEFT JOIN policies p ON i.id = p.initiative_id
GROUP BY i.id, i.description
ORDER BY policy_count DESC;