steampipe plugin install theapsgroup/gitlabsteampipe plugin install theapsgroup/gitlab

Table: gitlab_project_variable

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

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

Examples

List all variables for a project

select
  key,
  value,
  variable_type,
  environment_scope,
  masked,
  protected,
  raw
from
  gitlab_project_variable
where
  project_id = 173;

Get a specific variable for a project by key

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

Schema for gitlab_project_variable

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
environment_scope	text		The environment(s) that this variable is in scope for.
key	text	=	The key of the variable.
masked	boolean		Indicates if the variable is masked (hidden) in job logs.
project_id	bigint	=	The ID of the project this repository belongs to - link `gitlab_project.id`.
protected	boolean		Indicates if the variable is only applied to protected branches.
raw	boolean		Indicates if the variable is is a raw format.
value	text		The value of the variable.
variable_type	text		The type of the variable (env var, etc).