Skip to content
AWS for Query.Farm

aws.medical_imaging.get_image_set

Example SQL Queries

SELECT * FROM
aws.medical_imaging.get_image_set
WHERE
"datastore_id" = 'VALUE'
AND "image_set_id" = 'VALUE';

Description

Get image set properties.

Table Definition

Column NameColumn Data Type
datastore_id Required Input Column

The data store identifier.

VARCHAR
image_set_id Required Input Column

The image set identifier.

VARCHAR
version_id Input Column

The image set version identifier.

VARCHAR
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
    "type" VARCHAR,
    "name" VARCHAR,
    "account_id" VARCHAR,
    "via_profile_name" VARCHAR,
    "assumed_role_arn" VARCHAR,
    "organization" STRUCT(
        "account_name" VARCHAR,
        "id" VARCHAR,
        "tags" STRUCT(
            "key" VARCHAR,
            "value" VARCHAR
        )[],
        "master_account" STRUCT(
            "id" VARCHAR,
            "email" VARCHAR
        ),
        "parents" STRUCT(
            "type" VARCHAR,
            "id" VARCHAR,
            "name" VARCHAR,
            "tags" STRUCT(
                "key" VARCHAR,
                "value" VARCHAR
            )[]
        )[]
    )
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

created_at

The timestamp when image set properties were created.

TIMESTAMP_S
deleted_at

The timestamp when the image set properties were deleted.

TIMESTAMP_S
image_set_arn

The Amazon Resource Name (ARN) assigned to the image set.

VARCHAR
image_set_state

The image set state.

VARCHAR
image_set_workflow_status

The image set workflow status.

VARCHAR
message

The error message thrown if an image set action fails.

VARCHAR
overrides

This object contains the details of any overrides used while creating a specific image set version. If an image set was copied or updated using the force flag, this object will contain the forced flag.

STRUCT(
    "forced" BOOLEAN
)
Show child fields
overrides.forced

Setting this flag will force the CopyImageSet and UpdateImageSetMetadata operations, even if Patient, Study, or Series level metadata are mismatched.

updated_at

The timestamp when image set properties were updated.

TIMESTAMP_S