components

Schema reference for the components and components_latest SQL views — time series of tracked components with merged collector metadata per commit.

components
components_latest

The components view is a time series representation of the collection of components that Lunar monitors.

A subset of this data is available in the components_latest view, which contains only the latest git_sha for each pr, in each component. To get the latest row for the default branch, you can filter this view by pr IS NULL.

Schema

Column	Type	Description
component_id	TEXT	The identifier for the component - e.g. github.com/foo/bar/buz
timestamp	TIMESTAMP	The "committed at" UTC timestamp of the git_sha
git_sha	TEXT	The Git commit SHA of the component JSON
pr	BIGINT	The pull request number if the commit is part of a pull request. Set to NULL for the default branch
domain	TEXT	The domain of the component in dotted path format (e.g. payments.analytics.backend)
owner	TEXT	The owner of the component
tags	TEXT[]	The tags associated with the component
meta	JSONB	Arbitrary metadata associated with the component
component_json	JSONB	The component JSON object resulting from merging component JSON deltas of the different collectors that ran for this component

Notes

• To get the component data for a given component version, you need to filter by component_id, and git_sha. This pair uniquely identifies each row in the table.

• For repeated updates to the same commit SHA, the component_json is updated with the latest JSON object. Individual updates (or "deltas") can be accessed through the component_deltas view.

Usage examples

Find the latest data for a particular component on the default branch. This query is guaranteed to return at most one row.

SELECT *
FROM components_latest
WHERE component_id = 'github.com/foo/bar/buz'
  AND pr IS NULL;

Code coverage of a component over time.

SELECT timestamp,
       component_json->'codecov'->'report'->'result'->'coverage'->>'total' AS coverage
FROM components
WHERE component_id = 'github.com/foo/bar/buz'
  AND pr IS NULL
  AND jsonb_path_exists(component_json, '$.codecov.report.result.coverage.total')
ORDER BY timestamp ASC;

Histogram of Go versions used across all components within a domain.

SELECT component_json->'go'->>'version' AS go_version,
       COUNT(*) AS count
FROM components_latest
WHERE jsonb_path_exists(component_json, '$.go.version')
  AND (domain = 'analytics' OR domain LIKE 'analytics.%')
  AND pr IS NULL
GROUP BY go_version
ORDER BY count DESC;