turbot/steampipecloud
steampipe plugin install steampipecloud

Table: steampipecloud_workspace_mod

A Steampipe mod is a portable, versioned collection of related Steampipe resources such as dashboards, benchmarks, queries, and controls. Steampipe mods and mod resources are defined in HCL, and distributed as simple text files. Modules can be found on the Steampipe Hub, and may be shared with others from any public git repository.

Examples

Basic information about mods across all workspaces

select
id,
path,
alias,
constraint,
installed_version,
state
from
steampipecloud_workspace_mod;

List mods for all workspaces of the user

select
id,
path,
alias,
constraint,
installed_version,
state
from
steampipecloud_workspace_mod
where
identity_type = 'user';

List mods for all workspaces belonging to all organizations that the user is a member of

select
id,
path,
alias,
constraint,
installed_version,
state
from
steampipecloud_workspace_mod
where
identity_type = 'org';

List mods for a particular workspace belonging to an organization

select
swm.id,
swm.path,
swm.alias,
swm.constraint,
swm.installed_version,
swm.state
from
steampipecloud_workspace_mod as swm
inner join steampipecloud_organization as so on so.id = swm.identity_id
inner join steampipecloud_workspace as sw on sw.id = swm.workspace_id
where
so.handle = 'testorg'
and sw.handle = 'dev';

Schema for steampipecloud_workspace_mod

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
aliastext=Short name used to identify the mod.
constrainttextVersion constraint for the mod.
created_attimestamp with time zoneThe time when the mod was installed.
created_byjsonbInformation about the user who installed the mod.
created_by_idtextThe unique identifier of the user who installed the mod.
detailstextExtra stored details about the mod.
idtextThe unique identifier for the workspace mod.
identity_handletextThe handle of the identity which contains the workspace.
identity_idtext=The unique identifier for the identity which contains the workspace.
identity_typetextThe type of identity, which can be 'user' or 'org'.
installed_versiontextVersion of the mod installed.
pathtextFull path name for the mod.
statetextState of the mod. Can be one of 'installing', 'installed' or 'error'.
updated_attimestamp with time zoneThe time when the mod was last updated.
updated_byjsonbInformation about the user who last updated the mod.
updated_by_idtextThe unique identifier of the user who last updated the mod.
version_idbigintThe current version ID of the mod record.
workspace_handletextThe handle for the workspace.
workspace_idtext=The unique identifier for the workspace.