steampipe plugin install theapsgroup/gitlab

Table: gitlab_group_variable

The gitlab_group_variable table can be used to view information about variables within GitLab at the Group level.

However, you must specify a group_id in the where or join clause.

Examples

List all variables held against a group

select
key,
value,
variable_type,
environment_scope,
masked,
protected,
raw
from
gitlab_group_variable
where
group_id = 42;

Get a specific variable for a group by key

select
key,
value,
variable_type,
environment_scope,
masked,
protected,
raw
from
gitlab_group_variable
where
project_id = 42
and key = 'VARIABLE_NAME';

Schema for gitlab_group_variable

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
environment_scopetextThe environment(s) that this variable is in scope for.
group_idbigint=The ID of the group this repository belongs to - link `gitlab_group.id`.
keytext=The key of the variable.
maskedbooleanIndicates if the variable is masked (hidden) in job logs.
protectedbooleanIndicates if the variable is only applied to protected branches.
rawbooleanIndicates if the variable is is a raw format.
valuetextThe value of the variable.
variable_typetextThe type of the variable (env var, etc).