Skip to content
AWS for Query.Farm

aws.iotwireless.get_fuota_task

Example SQL Queries

SELECT * FROM
aws.iotwireless.get_fuota_task
WHERE
"id" = 'VALUE';

Description

Gets information about a FUOTA task.

Table Definition

Column NameColumn Data Type
id Required Input Column

The ID of a FUOTA task.

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
arn

The arn of a FUOTA task.

VARCHAR
created_at

Created at timestamp for the resource.

TIMESTAMP_S
description

The description of the new resource.

VARCHAR
firmware_update_image

The S3 URI points to a firmware update image that is to be used with a FUOTA task.

VARCHAR
firmware_update_role

The firmware update role that is to be used with a FUOTA task.

VARCHAR
fragment_interval_ms

The interval for sending fragments in milliseconds, rounded to the nearest second.

This interval only determines the timing for when the Cloud sends down the fragments to yor device. There can be a delay for when your device will receive these fragments. This delay depends on the device's class and the communication delay with the cloud.

BIGINT
fragment_size_bytes

The size of each fragment in bytes. This parameter is supported only for FUOTA tasks with multicast groups.

BIGINT
lo_ra_wan

The LoRaWAN information returned from getting a FUOTA task.

STRUCT(
    "rf_region" VARCHAR,
    "start_time" TIMESTAMP_S
)
Show child fields
lo_ra_wan.rf_region

The frequency band (RFRegion) value.

lo_ra_wan.start_time

Start time of a FUOTA task.

name

The name of a FUOTA task.

VARCHAR
redundancy_percent

The percentage of the added fragments that are redundant. For example, if the size of the firmware image file is 100 bytes and the fragment size is 10 bytes, with RedundancyPercent set to 50(%), the final number of encoded fragments is (100/10) + (100/10 * 50%) = 15.

BIGINT
status

The status of a FUOTA task.

VARCHAR