component_deltas
The component_deltas
view is a time series representation of the collection of component metadata deltas that Lunar collects.
A subset of this data is available in the component_deltas_latest
view, which contains only the deltas for the latest git_sha
in each pr
, in each component. To get the latest row for the default branch, you can filter this view by pr IS NULL
.
Schema
component_id
TEXT
The identifier for the component - e.g. github.com/foo/bar/buz
timestamp
TIMESTAMPTZ
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
collector_name
TEXT
The name of the collector that contributed this delta
collection_timestamp
TIMESTAMPTZ
The UTC timestamp when the collector ran
delta
JSONB
The metadata delta that was contributed by the collector
Notes
To get the set of deltas for a given component version, you need to filter by
component_id
, andgit_sha
. The ordering of these deltas is defined by thecollection_timestamp
.Merging these deltas in the order of
collection_timestamp
will give you the finalcomponent_json
object for a givencomponent_id
andgit_sha
that is found in thecomponents
view.The
timestamp
column (not to be confused withcollection_timestamp
) is guaranteed to be the same for a givengit_sha
of acomponent_id
. This timestamp will also match entries in other views such ascomponents
andchecks
.
Usage example
Retrieve the deltas associated with the latest git_sha
for a given component on the default branch.
Last updated