Skip to content
AWS for Query.Farm

aws.cleanroomsml.get_configured_audience_model

Example SQL Queries

SELECT * FROM
aws.cleanroomsml.get_configured_audience_model
WHERE
"configured_audience_model_arn" = 'VALUE';

Description

Returns information about a specified configured audience model.

Table Definition

Column NameColumn Data Type
configured_audience_model_arn Required Input Column

The Amazon Resource Name (ARN) of the configured audience model.

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.

audience_model_arn

The Amazon Resource Name (ARN) of the audience model used for this configured audience model.

VARCHAR
audience_size_config

The list of output sizes of audiences that can be created using this configured audience model. A request to StartAudienceGenerationJob that uses this configured audience model must have an audienceSize selected from this list. You can use the ABSOLUTE AudienceSize to configure out audience sizes using the count of identifiers in the output. You can use the Percentage AudienceSize to configure sizes in the range 1-100 percent.

STRUCT(
    "audience_size_type" VARCHAR,
    "audience_size_bins" BIGINT[]
)
Show child fields
audience_size_config.audience_size_bins[]
audience_size_config.audience_size_type

Whether the audience output sizes are defined as an absolute number or a percentage.

child_resource_tag_on_create_policy

Provides the childResourceTagOnCreatePolicy that was used for this configured audience model.

VARCHAR
create_time

The time at which the configured audience model was created.

TIMESTAMP_S
description

The description of the configured audience model.

VARCHAR
min_matching_seed_size

The minimum number of users from the seed audience that must match with users in the training data of the audience model.

BIGINT
name

The name of the configured audience model.

VARCHAR
output_config

The output configuration of the configured audience model

STRUCT(
    "destination" STRUCT(
        "s3_destination" STRUCT(
            "s3_uri" VARCHAR
        )
    ),
    "role_arn" VARCHAR
)
Show child fields
output_config.destination

Defines the Amazon S3 bucket where the configured audience is stored.

Show child fields
output_config.destination.s3_destination

The Amazon S3 bucket and path for the configured audience.

Show child fields
output_config.destination.s3_destination.s3_uri

The Amazon S3 location URI.

output_config.role_arn

The ARN of the IAM role that can write the Amazon S3 bucket.

shared_audience_metrics

Whether audience metrics are shared.

VARCHAR[]
Show child fields
shared_audience_metrics[]
status

The status of the configured audience model.

VARCHAR
tags

The tags that are associated to this configured audience model.

MAP(VARCHAR, VARCHAR)
update_time

The most recent time at which the configured audience model was updated.

TIMESTAMP_S