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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
alias	text	=	Short name used to identify the mod.
constraint	text		Version constraint for the mod.
created_at	timestamp with time zone		The time when the mod was installed.
created_by	jsonb		Information about the user who installed the mod.
created_by_id	text		The unique identifier of the user who installed the mod.
details	text		Extra stored details about the mod.
id	text		The unique identifier for the workspace mod.
identity_handle	text		The handle of the identity which contains the workspace.
identity_id	text	=	The unique identifier for the identity which contains the workspace.
identity_type	text		The type of identity, which can be 'user' or 'org'.
installed_version	text		Version of the mod installed.
path	text		Full path name for the mod.
state	text		State of the mod. Can be one of 'installing', 'installed' or 'error'.
updated_at	timestamp with time zone		The time when the mod was last updated.
updated_by	jsonb		Information about the user who last updated the mod.
updated_by_id	text		The unique identifier of the user who last updated the mod.
version_id	bigint		The current version ID of the mod record.
workspace_handle	text		The handle for the workspace.
workspace_id	text	=	The unique identifier for the workspace.