initiatives
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
name
TEXT
The identifier for the initiative
description
TEXT
A description of the initiative
owner
TEXT
The owner of the initiative
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 name;
Find initiatives owned by a specific person:
SELECT *
FROM initiatives
WHERE owner = '[email protected]';
Get a list of initiatives and the number of policies within each:
SELECT
i.name AS initiative_name,
i.description,
COUNT(p.name) AS policy_count
FROM initiatives i
LEFT JOIN policies p ON i.name = p.initiative_name
GROUP BY i.name, i.description
ORDER BY policy_count DESC;
Last updated