Skip to content
AWS for Query.Farm

aws.nimble.get_studio_component

Example SQL Queries

SELECT * FROM
aws.nimble.get_studio_component
WHERE
"studio_component_id" = 'VALUE'
AND "studio_id" = 'VALUE';

Description

Gets a studio component resource.

Table Definition

Column NameColumn Data Type
studio_component_id Required Input Column

The studio component ID.

VARCHAR
studio_id Required Input Column

The studio ID. 

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.

_aws_region Input Column

The AWS region to use.

VARCHAR
studio_component

Information about the studio component.

STRUCT(
    "arn" VARCHAR,
    "configuration" STRUCT(
        "active_directory_configuration" STRUCT(
            "computer_attributes" STRUCT(
                "name" VARCHAR,
                "value" VARCHAR
            )[],
            "directory_id" VARCHAR,
            "organizational_unit_distinguished_name" VARCHAR
        ),
        "compute_farm_configuration" STRUCT(
            "active_directory_user" VARCHAR,
            "endpoint" VARCHAR
        ),
        "license_service_configuration" STRUCT(
            "endpoint" VARCHAR
        ),
        "shared_file_system_configuration" STRUCT(
            "endpoint" VARCHAR,
            "file_system_id" VARCHAR,
            "linux_mount_point" VARCHAR,
            "share_name" VARCHAR,
            "windows_mount_drive" VARCHAR
        )
    ),
    "created_at" TIMESTAMP_S,
    "created_by" VARCHAR,
    "description" VARCHAR,
    "ec2_security_group_ids" VARCHAR[],
    "initialization_scripts" STRUCT(
        "launch_profile_protocol_version" VARCHAR,
        "platform" VARCHAR,
        "run_context" VARCHAR,
        "script" VARCHAR
    )[],
    "name" VARCHAR,
    "runtime_role_arn" VARCHAR,
    "script_parameters" STRUCT(
        "key" VARCHAR,
        "value" VARCHAR
    )[],
    "secure_initialization_role_arn" VARCHAR,
    "state" VARCHAR,
    "status_code" VARCHAR,
    "status_message" VARCHAR,
    "studio_component_id" VARCHAR,
    "subtype" VARCHAR,
    "tags" MAP(VARCHAR, VARCHAR),
    "type" VARCHAR,
    "updated_at" TIMESTAMP_S,
    "updated_by" VARCHAR
)
Show child fields
studio_component.arn

The Amazon Resource Name (ARN) that is assigned to a studio resource and uniquely identifies it. ARNs are unique across all Regions.

studio_component.configuration

The configuration of the studio component, based on component type.

Show child fields
studio_component.configuration.active_directory_configuration

The configuration for a Directory Service for Microsoft Active Directory studio resource.

Show child fields
studio_component.configuration.active_directory_configuration.computer_attributes[]
Show child fields
studio_component.configuration.active_directory_configuration.computer_attributes[].name

The name for the LDAP attribute.

studio_component.configuration.active_directory_configuration.computer_attributes[].value

The value for the LDAP attribute.

studio_component.configuration.active_directory_configuration.directory_id

The directory ID of the Directory Service for Microsoft Active Directory to access using this studio component.

studio_component.configuration.active_directory_configuration.organizational_unit_distinguished_name

The distinguished name (DN) and organizational unit (OU) of an Active Directory computer.

studio_component.configuration.compute_farm_configuration

The configuration for a render farm that is associated with a studio resource.

Show child fields
studio_component.configuration.compute_farm_configuration.active_directory_user

The name of an Active Directory user that is used on ComputeFarm worker instances.

studio_component.configuration.compute_farm_configuration.endpoint

The endpoint of the ComputeFarm that is accessed by the studio component resource.

studio_component.configuration.license_service_configuration

The configuration for a license service that is associated with a studio resource.

Show child fields
studio_component.configuration.license_service_configuration.endpoint

The endpoint of the license service that is accessed by the studio component resource.

studio_component.configuration.shared_file_system_configuration

The configuration for a shared file storage system that is associated with a studio resource.

Show child fields
studio_component.configuration.shared_file_system_configuration.endpoint

The endpoint of the shared file system that is accessed by the studio component resource.

studio_component.configuration.shared_file_system_configuration.file_system_id

The unique identifier for a file system.

studio_component.configuration.shared_file_system_configuration.linux_mount_point

The mount location for a shared file system on a Linux virtual workstation.

studio_component.configuration.shared_file_system_configuration.share_name

The name of the file share.

studio_component.configuration.shared_file_system_configuration.windows_mount_drive

The mount location for a shared file system on a Windows virtual workstation.

studio_component.created_at

The ISO timestamp in seconds for when the resource was created.

studio_component.created_by

The user ID of the user that created the studio component.

studio_component.description

A human-readable description for the studio component resource.

studio_component.ec2_security_group_ids[]
studio_component.initialization_scripts[]
Show child fields
studio_component.initialization_scripts[].launch_profile_protocol_version

The version number of the protocol that is used by the launch profile. The only valid version is "2021-03-31".

studio_component.initialization_scripts[].platform

The platform of the initialization script, either Windows or Linux.

studio_component.initialization_scripts[].run_context

The method to use when running the initialization script.

studio_component.initialization_scripts[].script

The initialization script.

studio_component.name

A friendly name for the studio component resource.

studio_component.runtime_role_arn

An IAM role attached to a Studio Component that gives the studio component access to Amazon Web Services resources at anytime while the instance is running.

studio_component.script_parameters[]
Show child fields
studio_component.script_parameters[].key

A script parameter key.

studio_component.script_parameters[].value

A script parameter value.

studio_component.secure_initialization_role_arn

An IAM role attached to Studio Component when the system initialization script runs which give the studio component access to Amazon Web Services resources when the system initialization script runs.

studio_component.state

The current state.

studio_component.status_code

The status code.

studio_component.status_message

The status message for the studio component.

studio_component.studio_component_id

The unique identifier for a studio component resource.

studio_component.subtype

The specific subtype of a studio component.

studio_component.tags

A collection of labels, in the form of key-value pairs, that apply to this resource.

studio_component.type

The type of the studio component.

studio_component.updated_at

The ISO timestamp in seconds for when the resource was updated.

studio_component.updated_by

The user ID of the user that most recently updated the resource.