Skip to content
AWS for Query.Farm

aws.connectcases.get_layout

Example SQL Queries

SELECT * FROM
aws.connectcases.get_layout
WHERE
"domain_id" = 'VALUE'
AND "layout_id" = 'VALUE';

Description

Returns the details for the requested layout.

Table Definition

Column NameColumn Data Type
domain_id Required Input Column

The unique identifier of the Cases domain. 

VARCHAR
layout_id Required Input Column

The unique identifier of the layout.

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.

content

Information about which fields will be present in the layout, the order of the fields, and read-only attribute of the field. 

STRUCT(
    "basic" STRUCT(
        "more_info" STRUCT(
            "sections" STRUCT(
                "field_group" STRUCT(
                    "fields" STRUCT(
                        "id" VARCHAR
                    )[],
                    "name" VARCHAR
                )
            )[]
        ),
        "top_panel" STRUCT(
            "sections" STRUCT(
                "field_group" STRUCT(
                    "fields" STRUCT(
                        "id" VARCHAR
                    )[],
                    "name" VARCHAR
                )
            )[]
        )
    )
)
Show child fields
content.basic

Content specific to BasicLayout type. It configures fields in the top panel and More Info tab of Cases user interface.

Show child fields
content.basic.more_info

This represents sections in a tab of the page layout.

Show child fields
content.basic.more_info.sections[]
Show child fields
content.basic.more_info.sections[].field_group

Consists of a group of fields and associated properties.

Show child fields
content.basic.more_info.sections[].field_group.fields[]
Show child fields
content.basic.more_info.sections[].field_group.fields[].id

Unique identifier of a field.

content.basic.more_info.sections[].field_group.name

Name of the field group.

content.basic.top_panel

This represents sections in a panel of the page layout.

Show child fields
content.basic.top_panel.sections[]
Show child fields
content.basic.top_panel.sections[].field_group

Consists of a group of fields and associated properties.

Show child fields
content.basic.top_panel.sections[].field_group.fields[]
Show child fields
content.basic.top_panel.sections[].field_group.fields[].id

Unique identifier of a field.

content.basic.top_panel.sections[].field_group.name

Name of the field group.

created_time

Timestamp at which the resource was created.

TIMESTAMP_S
deleted

Denotes whether or not the resource has been deleted.

BOOLEAN
last_modified_time

Timestamp at which the resource was created or last modified.

TIMESTAMP_S
layout_arn

The Amazon Resource Name (ARN) of the newly created layout.

VARCHAR
name

The name of the layout. It must be unique.

VARCHAR
tags

A map of of key-value pairs that represent tags on a resource. Tags are used to organize, track, or control access for this resource.

MAP(VARCHAR, VARCHAR)