Skip to content
AWS for Query.Farm

aws.devicefarm.list_runs

Example SQL Queries

SELECT * FROM
aws.devicefarm.list_runs
WHERE
"arn" = 'VALUE';

Description

Gets information about runs, given an AWS Device Farm project ARN.

Table Definition

Column NameColumn Data Type
arn Required Input Column

The run's ARN.

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
app_upload

An app to upload or that has been uploaded.

VARCHAR
billing_method

Specifies the billing method for a test run: metered or unmetered. If the parameter is not specified, the default value is metered.

If you have unmetered device slots, you must set this to unmetered to use them. Otherwise, the run is counted toward metered device minutes.

VARCHAR
completed_jobs

The total number of completed jobs.

BIGINT
counters

The run's result counters.

STRUCT(
    "total" BIGINT,
    "passed" BIGINT,
    "failed" BIGINT,
    "warned" BIGINT,
    "errored" BIGINT,
    "stopped" BIGINT,
    "skipped" BIGINT
)
Show child fields
counters.errored

The number of errored entities.

counters.failed

The number of failed entities.

counters.passed

The number of passed entities.

counters.skipped

The number of skipped entities.

counters.stopped

The number of stopped entities.

counters.total

The total number of entities.

counters.warned

The number of warned entities.

created

When the run was created.

TIMESTAMP_S
customer_artifact_paths

Output CustomerArtifactPaths object for the test run.

STRUCT(
    "ios_paths" VARCHAR[],
    "android_paths" VARCHAR[],
    "device_host_paths" VARCHAR[]
)
Show child fields
customer_artifact_paths.android_paths[]
customer_artifact_paths.device_host_paths[]
customer_artifact_paths.ios_paths[]
device_minutes

Represents the total (metered or unmetered) minutes used by the test run.

STRUCT(
    "total" DOUBLE,
    "metered" DOUBLE,
    "unmetered" DOUBLE
)
Show child fields
device_minutes.metered

When specified, represents only the sum of metered minutes used by the resource to run tests.

device_minutes.total

When specified, represents the total minutes used by the resource to run tests.

device_minutes.unmetered

When specified, represents only the sum of unmetered minutes used by the resource to run tests.

device_pool_arn

The ARN of the device pool for the run.

VARCHAR
device_selection_result

The results of a device filter used to select the devices for a test run.

STRUCT(
    "filters" STRUCT(
        "attribute" VARCHAR,
        "operator" VARCHAR,
        "values" VARCHAR[]
    )[],
    "matched_devices_count" BIGINT,
    "max_devices" BIGINT
)
Show child fields
device_selection_result.filters[]
Show child fields
device_selection_result.filters[].attribute

The aspect of a device such as platform or model used as the selection criteria in a device filter.

The supported operators for each attribute are provided in the following list.

ARN

The Amazon Resource Name (ARN) of the device (for example, arn:aws:devicefarm:us-west-2::device:12345Example).

Supported operators: EQUALS, IN, NOT_IN

PLATFORM

The device platform. Valid values are ANDROID or IOS.

Supported operators: EQUALS

OS_VERSION

The operating system version (for example, 10.3.2).

Supported operators: EQUALS, GREATER_THAN, GREATER_THAN_OR_EQUALS, IN, LESS_THAN, LESS_THAN_OR_EQUALS, NOT_IN

MODEL

The device model (for example, iPad 5th Gen).

Supported operators: CONTAINS, EQUALS, IN, NOT_IN

AVAILABILITY

The current availability of the device. Valid values are AVAILABLE, HIGHLY_AVAILABLE, BUSY, or TEMPORARY_NOT_AVAILABLE.

Supported operators: EQUALS

FORM_FACTOR

The device form factor. Valid values are PHONE or TABLET.

Supported operators: EQUALS

MANUFACTURER

The device manufacturer (for example, Apple).

Supported operators: EQUALS, IN, NOT_IN

REMOTE_ACCESS_ENABLED

Whether the device is enabled for remote access. Valid values are TRUE or FALSE.

Supported operators: EQUALS

REMOTE_DEBUG_ENABLED

Whether the device is enabled for remote debugging. Valid values are TRUE or FALSE.

Supported operators: EQUALS

Because remote debugging is no longer supported, this filter is ignored.

INSTANCE_ARN

The Amazon Resource Name (ARN) of the device instance.

Supported operators: EQUALS, IN, NOT_IN

INSTANCE_LABELS

The label of the device instance.

Supported operators: CONTAINS

FLEET_TYPE

The fleet type. Valid values are PUBLIC or PRIVATE.

Supported operators: EQUALS

device_selection_result.filters[].operator

Specifies how Device Farm compares the filter's attribute to the value. See the attribute descriptions.

device_selection_result.filters[].values[]
device_selection_result.matched_devices_count

The number of devices that matched the device filter selection criteria.

device_selection_result.max_devices

The maximum number of devices to be selected by a device filter and included in a test run.

event_count

For fuzz tests, this is the number of events, between 1 and 10000, that the UI fuzz test should perform.

BIGINT
job_timeout_minutes

The number of minutes the job executes before it times out.

BIGINT
locale

Information about the locale that is used for the run.

VARCHAR
location

Information about the location that is used for the run.

STRUCT(
    "latitude" DOUBLE,
    "longitude" DOUBLE
)
Show child fields
location.latitude

The latitude.

location.longitude

The longitude.

message

A message about the run's result.

VARCHAR
name

The run's name.

VARCHAR
network_profile

The network profile being used for a test run.

STRUCT(
    "arn" VARCHAR,
    "name" VARCHAR,
    "description" VARCHAR,
    "type" VARCHAR,
    "uplink_bandwidth_bits" BIGINT,
    "downlink_bandwidth_bits" BIGINT,
    "uplink_delay_ms" BIGINT,
    "downlink_delay_ms" BIGINT,
    "uplink_jitter_ms" BIGINT,
    "downlink_jitter_ms" BIGINT,
    "uplink_loss_percent" BIGINT,
    "downlink_loss_percent" BIGINT
)
Show child fields
network_profile.arn

The Amazon Resource Name (ARN) of the network profile.

network_profile.description

The description of the network profile.

network_profile.downlink_bandwidth_bits

The data throughput rate in bits per second, as an integer from 0 to 104857600.

network_profile.downlink_delay_ms

Delay time for all packets to destination in milliseconds as an integer from 0 to 2000.

network_profile.downlink_jitter_ms

Time variation in the delay of received packets in milliseconds as an integer from 0 to 2000.

network_profile.downlink_loss_percent

Proportion of received packets that fail to arrive from 0 to 100 percent.

network_profile.name

The name of the network profile.

network_profile.type

The type of network profile. Valid values are listed here.

network_profile.uplink_bandwidth_bits

The data throughput rate in bits per second, as an integer from 0 to 104857600.

network_profile.uplink_delay_ms

Delay time for all packets to destination in milliseconds as an integer from 0 to 2000.

network_profile.uplink_jitter_ms

Time variation in the delay of received packets in milliseconds as an integer from 0 to 2000.

network_profile.uplink_loss_percent

Proportion of transmitted packets that fail to arrive from 0 to 100 percent.

parsing_result_url

Read-only URL for an object in an S3 bucket where you can get the parsing results of the test package. If the test package doesn't parse, the reason why it doesn't parse appears in the file that this URL points to.

VARCHAR
platform

The run's platform.

Allowed values include:

  • ANDROID

  • IOS

VARCHAR
radios

Information about the radio states for the run.

STRUCT(
    "wifi" BOOLEAN,
    "bluetooth" BOOLEAN,
    "nfc" BOOLEAN,
    "gps" BOOLEAN
)
Show child fields
radios.bluetooth

True if Bluetooth is enabled at the beginning of the test. Otherwise, false.

radios.gps

True if GPS is enabled at the beginning of the test. Otherwise, false.

radios.nfc

True if NFC is enabled at the beginning of the test. Otherwise, false.

radios.wifi

True if Wi-Fi is enabled at the beginning of the test. Otherwise, false.

result

The run's result.

Allowed values include:

  • PENDING

  • PASSED

  • WARNED

  • FAILED

  • SKIPPED

  • ERRORED

  • STOPPED

VARCHAR
result_code

Supporting field for the result field. Set only if result is SKIPPED. PARSING_FAILED if the result is skipped because of test package parsing failure.

VARCHAR
seed

For fuzz tests, this is a seed to use for randomizing the UI fuzz test. Using the same seed value between tests ensures identical event sequences.

BIGINT
skip_app_resign

When set to true, for private devices, Device Farm does not sign your app again. For public devices, Device Farm always signs your apps again.

For more information about how Device Farm re-signs your apps, see Do you modify my app? in the AWS Device Farm FAQs.

BOOLEAN
started

The run's start time.

TIMESTAMP_S
status

The run's status.

Allowed values include:

  • PENDING

  • PENDING_CONCURRENCY

  • PENDING_DEVICE

  • PROCESSING

  • SCHEDULING

  • PREPARING

  • RUNNING

  • COMPLETED

  • STOPPING

VARCHAR
stopped

The run's stop time.

TIMESTAMP_S
test_spec_arn

The ARN of the YAML-formatted test specification for the run.

VARCHAR
total_jobs

The total number of jobs for the run.

BIGINT
type

The run's type.

Must be one of the following values:

  • BUILTIN_FUZZ

  • BUILTIN_EXPLORER

    For Android, an app explorer that traverses an Android app, interacting with it and capturing screenshots at the same time.

  • APPIUM_JAVA_JUNIT

  • APPIUM_JAVA_TESTNG

  • APPIUM_PYTHON

  • APPIUM_NODE

  • APPIUM_RUBY

  • APPIUM_WEB_JAVA_JUNIT

  • APPIUM_WEB_JAVA_TESTNG

  • APPIUM_WEB_PYTHON

  • APPIUM_WEB_NODE

  • APPIUM_WEB_RUBY

  • CALABASH

  • INSTRUMENTATION

  • UIAUTOMATION

  • UIAUTOMATOR

  • XCTEST

  • XCTEST_UI

VARCHAR
vpc_config

The VPC security groups and subnets that are attached to a project.

STRUCT(
    "security_group_ids" VARCHAR[],
    "subnet_ids" VARCHAR[],
    "vpc_id" VARCHAR
)
Show child fields
vpc_config.security_group_ids[]
vpc_config.subnet_ids[]
vpc_config.vpc_id

The ID of the Amazon VPC.

web_url

The Device Farm console URL for the recording of the run.

VARCHAR