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;

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