steampipe plugin install aws

Table: aws_simspaceweaver_simulation - Query AWS SimSpace Simulation using SQL

The AWS SimSpace Simulation is a service within the Amazon Web Services infrastructure that enables users to create, run, and manage simulations at scale. It's part of the AWS SimSpace offering, which is designed to provide computational simulation as a service. This service eliminates the need for managing the underlying compute resources, allowing users to focus on analyzing results and optimizing designs.

Table Usage Guide

The aws_simspaceweaver_simulation table in Steampipe provides you with information about simulations within AWS SimSpace. This table allows you to query simulation-specific details, including simulation status, configuration, and associated metadata. You can utilize this table to gather insights on simulations, such as simulation state, configuration details, and more. The schema outlines the various attributes of the simulation for you, including the simulation ID, creation time, status, and associated tags.

Examples

Basic info

Explore which AWS SimSpaceWeaver simulations have been created and their current status. This can help in identifying and addressing any potential issues with these simulations.

select
name,
arn,
creation_time,
status,
execution_id,
schema_error
from
aws_simspaceweaver_simulation;
select
name,
arn,
creation_time,
status,
execution_id,
schema_error
from
aws_simspaceweaver_simulation;

List simulations older than 30 days

Identify instances where simulations have been running for more than 30 days. This can be useful for managing resources and ensuring simulations are not unnecessarily consuming resources.

select
name,
arn,
creation_time,
status
from
aws_simspaceweaver_simulation
where
creation_time >= now() - interval '30' day;
select
name,
arn,
creation_time,
status
from
aws_simspaceweaver_simulation
where
creation_time >= datetime('now', '-30 day');

List failed simulations

Identify instances where simulations have been unsuccessful to assess potential issues or errors within the AWS SimSpaceWeaver system.

select
name,
arn,
creation_time,
status
from
aws_simspaceweaver_simulation
where
status = 'FAILED';
select
name,
arn,
creation_time,
status
from
aws_simspaceweaver_simulation
where
status = 'FAILED';

Get logging configurations of simulations

Analyze the settings to understand the logging configurations of your AWS SimSpaceWeaver simulations. This can be useful to ensure that your logging configurations are correctly set up and to troubleshoot any issues that may arise during your simulations.

select
name,
arn,
jsonb_pretty(d)
from
aws_simspaceweaver_simulation,
jsonb_array_elements(logging_configuration -> 'Destinations') as d;
select
name,
arn,
json_extract(d.value, '$') as d
from
aws_simspaceweaver_simulation,
json_each(logging_configuration, '$.Destinations') as d;

Get S3 bucket details of simulations

Determine the areas in which simulations and S3 bucket details intersect. This can be useful for gaining insights into simulation configurations and assessing how they align with your S3 bucket settings, particularly in terms of versioning, public access, and access control lists.

select
s.name,
s.arn,
s.schema_s3_location ->> 'BucketName' as bucket_name,
s.schema_s3_location ->> 'ObjectKey' as object_key,
b.versioning_enabled,
b.block_public_acls,
b.acl
from
aws_simspaceweaver_simulation as s,
aws_s3_bucket as b
where
s.schema_s3_location ->> 'BucketName' = b.name;
select
s.name,
s.arn,
json_extract(s.schema_s3_location, '$.BucketName') as bucket_name,
json_extract(s.schema_s3_location, '$.ObjectKey') as object_key,
b.versioning_enabled,
b.block_public_acls,
b.acl
from
aws_simspaceweaver_simulation as s,
aws_s3_bucket as b
where
json_extract(s.schema_s3_location, '$.BucketName') = b.name;

Schema for aws_simspaceweaver_simulation

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
account_idtextThe AWS Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
arntextThe Amazon Resource Name (ARN) of the simulation.
creation_timetimestamp with time zoneThe time when the simulation was created, expressed as the number of seconds and milliseconds in UTC since the Unix epoch (0:0:0.000, January 1, 1970).
execution_idtextA universally unique identifier (UUID) for this simulation.
live_simulation_statejsonbA collection of additional state information, such as domain and clock configuration.
logging_configurationjsonbSettings that control how SimSpace Weaver handles your simulation log data.
maximum_durationtextThe maximum running time of the simulation, specified as a number of months (m or M), hours (h or H), or days (d or D).
nametext=The name of the simulation.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
regiontextThe AWS Region in which the resource is located.
role_arntextThe Amazon Resource Name (ARN) of the Identity and Access Management (IAM) role that the simulation assumes to perform actions.
schema_errortextAn error message that SimSpace Weaver returns only if there is a problem with the simulation schema.
schema_s3_locationjsonbThe location of the simulation schema in Amazon Simple Storage Service (Amazon S3).
statustextThe current status of the simulation.
tagsjsonbA map of tags for the resource.
target_statusjsonbThe desired status of the simulation.
titletextTitle of the resource.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- aws

You can pass the configuration to the command with the --config argument:

steampipe_export_aws --config '<your_config>' aws_simspaceweaver_simulation