Skip to content
AWS for Query.Farm

aws.evidently.get_project

Example SQL Queries

SELECT * FROM
aws.evidently.get_project
WHERE
"project" = 'VALUE';

Description

Returns the details about one launch. You must already know the project name. To retrieve a list of projects in your account, use ListProjects.

Table Definition

Column NameColumn Data Type
_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
_input_project Input Column
VARCHAR
project

A structure containing the configuration details of the project.

STRUCT(
    "active_experiment_count" BIGINT,
    "active_launch_count" BIGINT,
    "app_config_resource" STRUCT(
        "application_id" VARCHAR,
        "configuration_profile_id" VARCHAR,
        "environment_id" VARCHAR
    ),
    "arn" VARCHAR,
    "created_time" TIMESTAMP_S,
    "data_delivery" STRUCT(
        "cloud_watch_logs" STRUCT(
            "log_group" VARCHAR
        ),
        "s3_destination" STRUCT(
            "bucket" VARCHAR,
            "prefix" VARCHAR
        )
    ),
    "description" VARCHAR,
    "experiment_count" BIGINT,
    "feature_count" BIGINT,
    "last_updated_time" TIMESTAMP_S,
    "launch_count" BIGINT,
    "name" VARCHAR,
    "status" VARCHAR,
    "tags" MAP(VARCHAR, VARCHAR)
)
Show child fields
project.active_experiment_count

The number of ongoing experiments currently in the project.

project.active_launch_count

The number of ongoing launches currently in the project.

project.app_config_resource

This structure defines the configuration of how your application integrates with AppConfig to run client-side evaluation.

Show child fields
project.app_config_resource.application_id

The ID of the AppConfig application to use for client-side evaluation.

project.app_config_resource.configuration_profile_id

The ID of the AppConfig profile to use for client-side evaluation.

project.app_config_resource.environment_id

The ID of the AppConfig environment to use for client-side evaluation. This must be an environment that is within the application that you specify for applicationId.

project.arn

The name or ARN of the project.

project.created_time

The date and time that the project is created.

project.data_delivery

A structure that contains information about where Evidently is to store evaluation events for longer term storage.

Show child fields
project.data_delivery.cloud_watch_logs

If the project stores evaluation events in CloudWatch Logs, this structure stores the log group name.

Show child fields
project.data_delivery.cloud_watch_logs.log_group

The name of the log group where the project stores evaluation events.

project.data_delivery.s3_destination

If the project stores evaluation events in an Amazon S3 bucket, this structure stores the bucket name and bucket prefix.

Show child fields
project.data_delivery.s3_destination.bucket

The name of the bucket in which Evidently stores evaluation events.

project.data_delivery.s3_destination.prefix

The bucket prefix in which Evidently stores evaluation events.

project.description

The user-entered description of the project.

project.experiment_count

The number of experiments currently in the project. This includes all experiments that have been created and not deleted, whether they are ongoing or not.

project.feature_count

The number of features currently in the project.

project.last_updated_time

The date and time that the project was most recently updated.

project.launch_count

The number of launches currently in the project. This includes all launches that have been created and not deleted, whether they are ongoing or not.

project.name

The name of the project.

project.status

The current state of the project.

project.tags

The list of tag keys and values associated with this project.