Table: aws_simspaceweaver_simulation

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

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
  status = 'FAILED';

select
  name,
  arn,
  jsonb_pretty(d)
from
  aws_simspaceweaver_simulation,
  jsonb_array_elements(logging_configuration -> 'Destinations') as d;

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;