Skip to content
AWS for Query.Farm

aws.iotfleetwise.get_register_account_status

Example SQL Queries

SELECT * FROM
aws.iotfleetwise.get_register_account_status;

Description

Retrieves information about the status of registering your Amazon Web Services account, IAM, and Amazon Timestream resources so that Amazon Web Services IoT FleetWise can transfer your vehicle data to the Amazon Web Services Cloud.

For more information, including step-by-step procedures, see Setting up Amazon Web Services IoT FleetWise.

This API operation doesn't require input parameters.

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
account_status

The status of registering your account and resources. The status can be one of:

  • REGISTRATION_SUCCESS - The Amazon Web Services resource is successfully registered.

  • REGISTRATION_PENDING - Amazon Web Services IoT FleetWise is processing the registration request. This process takes approximately five minutes to complete.

  • REGISTRATION_FAILURE - Amazon Web Services IoT FleetWise can't register the AWS resource. Try again later.

VARCHAR
creation_time

The time the account was registered, in seconds since epoch (January 1, 1970 at midnight UTC time). 

TIMESTAMP_S
customer_account_id

The unique ID of the Amazon Web Services account, provided at account creation. 

VARCHAR
iam_registration_response

Information about the registered IAM resources or errors, if any. 

STRUCT(
    "role_arn" VARCHAR,
    "registration_status" VARCHAR,
    "error_message" VARCHAR
)
Show child fields
iam_registration_response.error_message

A message associated with a registration error.

iam_registration_response.registration_status

The status of registering your IAM resource. The status can be one of REGISTRATION_SUCCESS, REGISTRATION_PENDING, REGISTRATION_FAILURE.

iam_registration_response.role_arn

The Amazon Resource Name (ARN) of the IAM role to register.

last_modification_time

The time this registration was last updated, in seconds since epoch (January 1, 1970 at midnight UTC time). 

TIMESTAMP_S
timestream_registration_response

Information about the registered Amazon Timestream resources or errors, if any.

STRUCT(
    "timestream_database_name" VARCHAR,
    "timestream_table_name" VARCHAR,
    "timestream_database_arn" VARCHAR,
    "timestream_table_arn" VARCHAR,
    "registration_status" VARCHAR,
    "error_message" VARCHAR
)
Show child fields
timestream_registration_response.error_message

A message associated with a registration error.

timestream_registration_response.registration_status

The status of registering your Amazon Timestream resources. The status can be one of REGISTRATION_SUCCESS, REGISTRATION_PENDING, REGISTRATION_FAILURE.

timestream_registration_response.timestream_database_arn

The Amazon Resource Name (ARN) of the Timestream database.

timestream_registration_response.timestream_database_name

The name of the Timestream database.

timestream_registration_response.timestream_table_arn

The ARN of the Timestream database table.

timestream_registration_response.timestream_table_name

The name of the Timestream database table.