scalingo_addonscalingo_alertscalingo_appscalingo_app_eventscalingo_autoscalerscalingo_collaboratorscalingo_containerscalingo_container_typescalingo_cronscalingo_databasescalingo_database_backupscalingo_database_maintenancescalingo_database_type_versionscalingo_database_userscalingo_deploymentscalingo_domainscalingo_environmentscalingo_event_typescalingo_invoicescalingo_keyscalingo_log_drainscalingo_log_drain_addonscalingo_notification_platformscalingo_notifierscalingo_regionscalingo_scm_integrationscalingo_scm_repo_linkscalingo_stackscalingo_tokenscalingo_user_eventscalingo_user_scm_repo_link
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, emailfrom scalingo_collaboratorwhere app_name = 'caresteouvert-api';
Get all collaborators from all apps
select distinct(c.email) as emailfrom scalingo_collaborator as c inner join scalingo_app as a on a.name = c.app_name;
Schema for scalingo_collaborator
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form. | |
app_id | text | ID of the application where the collaborator belong. | |
app_name | text | = | Name of the app. |
text | Email of the collaborator. | ||
id | text | Unique ID identifying the collaborator. | |
sp_connection_name | text | =, !=, ~~, ~~*, !~~, !~~* | Steampipe connection name. |
sp_ctx | jsonb | Steampipe context in JSON form. | |
status | text | Status of the invitation. | |
user_id | text | User id of the collaborator. | |
username | text | Username of the collaborator. |