Skip to content
AWS for Query.Farm

aws.emr.describe_studio

Example SQL Queries

SELECT * FROM
aws.emr.describe_studio
WHERE
"studio_id" = 'VALUE';

Description

Returns details for the specified Amazon EMR Studio including ID, Name, VPC, Studio access URL, and so on.

Table Definition

Column NameColumn Data Type
studio_id Required Input Column

The Amazon EMR 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.

studio

The Amazon EMR Studio details.

STRUCT(
    "studio_id" VARCHAR,
    "studio_arn" VARCHAR,
    "name" VARCHAR,
    "description" VARCHAR,
    "auth_mode" VARCHAR,
    "vpc_id" VARCHAR,
    "subnet_ids" VARCHAR[],
    "service_role" VARCHAR,
    "user_role" VARCHAR,
    "workspace_security_group_id" VARCHAR,
    "engine_security_group_id" VARCHAR,
    "url" VARCHAR,
    "creation_time" TIMESTAMP_S,
    "default_s3_location" VARCHAR,
    "idp_auth_url" VARCHAR,
    "idp_relay_state_parameter_name" VARCHAR,
    "tags" STRUCT(
        "key" VARCHAR,
        "value" VARCHAR
    )[],
    "idc_instance_arn" VARCHAR,
    "trusted_identity_propagation_enabled" BOOLEAN,
    "idc_user_assignment" VARCHAR,
    "encryption_key_arn" VARCHAR
)
Show child fields
studio.auth_mode

Specifies whether the Amazon EMR Studio authenticates users with IAM or IAM Identity Center.

studio.creation_time

The time the Amazon EMR Studio was created.

studio.default_s3_location

The Amazon S3 location to back up Amazon EMR Studio Workspaces and notebook files.

studio.description

The detailed description of the Amazon EMR Studio.

studio.encryption_key_arn

The KMS key identifier (ARN) used to encrypt Amazon EMR Studio workspace and notebook files when backed up to Amazon S3.

studio.engine_security_group_id

The ID of the Engine security group associated with the Amazon EMR Studio. The Engine security group allows inbound network traffic from resources in the Workspace security group.

studio.idc_instance_arn

The ARN of the IAM Identity Center instance the Studio application belongs to.

studio.idc_user_assignment

Indicates whether the Studio has REQUIRED or OPTIONAL IAM Identity Center user assignment. If the value is set to REQUIRED, users must be explicitly assigned to the Studio application to access the Studio.

studio.idp_auth_url

Your identity provider's authentication endpoint. Amazon EMR Studio redirects federated users to this endpoint for authentication when logging in to a Studio with the Studio URL.

studio.idp_relay_state_parameter_name

The name of your identity provider's RelayState parameter.

studio.name

The name of the Amazon EMR Studio.

studio.service_role

The name of the IAM role assumed by the Amazon EMR Studio.

studio.studio_arn

The Amazon Resource Name (ARN) of the Amazon EMR Studio.

studio.studio_id

The ID of the Amazon EMR Studio.

studio.subnet_ids[]
studio.tags[]
Show child fields
studio.tags[].key

A user-defined key, which is the minimum required information for a valid tag. For more information, see Tag.

studio.tags[].value

A user-defined value, which is optional in a tag. For more information, see Tag Clusters.

studio.trusted_identity_propagation_enabled

Indicates whether the Studio has Trusted identity propagation enabled. The default value is false.

studio.url

The unique access URL of the Amazon EMR Studio.

studio.user_role

The name of the IAM role assumed by users logged in to the Amazon EMR Studio. A Studio only requires a UserRole when you use IAM authentication.

studio.vpc_id

The ID of the VPC associated with the Amazon EMR Studio.

studio.workspace_security_group_id

The ID of the Workspace security group associated with the Amazon EMR Studio. The Workspace security group allows outbound network traffic to resources in the Engine security group and to the internet.