steampipe plugin install francois2metz/scalingo

Table: scalingo_notification_platform

List notification platforms that can be used on notifier.

Examples

List notification platforms

select
id,
name
from
scalingo_notification_platform;

Get notification platform used by a notifier

select
np.name,
np.display_name,
n.name
from
scalingo_notifier n
join scalingo_notification_platform np on np.id = n.platform_id
where
n.app_name = 'caresteouvert-api';

Schema for scalingo_notification_platform

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
available_event_idsjsonbList of event IDs accepted by this platform.
descriptiontextDescription of the platform.
display_nametextHuman readable name for this notification platform.
idtextUnique ID identifying the notification platform.
logo_urltextURL to a logo for this notification platform.
nametextName of the notification platform.
regiontextThe region associated to this notification platform.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.