steampipecloud_audit_logsteampipecloud_connectionsteampipecloud_organizationsteampipecloud_organization_membersteampipecloud_organization_workspace_membersteampipecloud_processsteampipecloud_tokensteampipecloud_usersteampipecloud_user_emailsteampipecloud_user_preferencessteampipecloud_workspacesteampipecloud_workspace_aggregatorsteampipecloud_workspace_connectionsteampipecloud_workspace_db_logsteampipecloud_workspace_modsteampipecloud_workspace_mod_variablesteampipecloud_workspace_pipelinesteampipecloud_workspace_processsteampipecloud_workspace_snapshot
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, statefrom steampipecloud_workspace_mod;
List mods for all workspaces of the user
select id, path, alias, constraint, installed_version, statefrom steampipecloud_workspace_modwhere 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, statefrom steampipecloud_workspace_modwhere 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.statefrom 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_idwhere 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. |