steampipe plugin install francois2metz/scalingo

Table: scalingo_collaborator

A collaborator can access a scalingo application.

The scalingo_collaborator table can be used to query information about app collaborators, and you must specify which application in the where or join clause using the app_name column.

Examples

List collaborators of an application

select
status,
email
from
scalingo_collaborator
where
app_name = 'caresteouvert-api';

Get all collaborators from all apps

select
distinct(c.email) as email
from
scalingo_collaborator as c
inner join scalingo_app as a on a.name = c.app_name;

Schema for scalingo_collaborator

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
app_idtextID of the application where the collaborator belong.
app_nametext=Name of the app.
emailtextEmail of the collaborator.
idtextUnique ID identifying the collaborator.
statustextStatus of the invitation.
user_idtextUser id of the collaborator.
usernametextUsername of the collaborator.