Skip to content
AWS for Query.Farm

aws.iotfleetwise.list_signal_catalog_nodes

Example SQL Queries

SELECT * FROM
aws.iotfleetwise.list_signal_catalog_nodes
WHERE
"name" = 'VALUE';

Description

Lists of information about the signals (nodes) specified in a signal catalog.

This API operation uses pagination. Specify the nextToken parameter in the request to return more results.

Table Definition

Column NameColumn Data Type
name Required Input Column

The name of the signal catalog to list information about. 

VARCHAR
signal_node_type Input Column

The type of node in the signal catalog.

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
actuator

Information about a node specified as an actuator.

An actuator is a digital representation of a vehicle device.

STRUCT(
    "fully_qualified_name" VARCHAR,
    "data_type" VARCHAR,
    "description" VARCHAR,
    "unit" VARCHAR,
    "allowed_values" VARCHAR[],
    "min" DOUBLE,
    "max" DOUBLE,
    "assigned_value" VARCHAR,
    "deprecation_message" VARCHAR,
    "comment" VARCHAR,
    "struct_fully_qualified_name" VARCHAR
)
Show child fields
actuator.allowed_values[]
actuator.assigned_value

A specified value for the actuator.

actuator.comment

A comment in addition to the description.

actuator.data_type

The specified data type of the actuator.

actuator.deprecation_message

The deprecation message for the node or the branch that was moved or deleted.

actuator.description

A brief description of the actuator.

actuator.fully_qualified_name

The fully qualified name of the actuator. For example, the fully qualified name of an actuator might be Vehicle.Front.Left.Door.Lock.

actuator.max

The specified possible maximum value of an actuator.

actuator.min

The specified possible minimum value of an actuator.

actuator.struct_fully_qualified_name

The fully qualified name of the struct node for the actuator if the data type of the actuator is Struct or StructArray. For example, the struct fully qualified name of an actuator might be Vehicle.Door.LockStruct.

actuator.unit

The scientific unit for the actuator.

attribute

Information about a node specified as an attribute.

An attribute represents static information about a vehicle.

STRUCT(
    "fully_qualified_name" VARCHAR,
    "data_type" VARCHAR,
    "description" VARCHAR,
    "unit" VARCHAR,
    "allowed_values" VARCHAR[],
    "min" DOUBLE,
    "max" DOUBLE,
    "assigned_value" VARCHAR,
    "default_value" VARCHAR,
    "deprecation_message" VARCHAR,
    "comment" VARCHAR
)
Show child fields
attribute.allowed_values[]
attribute.assigned_value

A specified value for the attribute.

attribute.comment

A comment in addition to the description.

attribute.data_type

The specified data type of the attribute.

attribute.default_value

The default value of the attribute.

attribute.deprecation_message

The deprecation message for the node or the branch that was moved or deleted.

attribute.description

A brief description of the attribute.

attribute.fully_qualified_name

The fully qualified name of the attribute. For example, the fully qualified name of an attribute might be Vehicle.Body.Engine.Type.

attribute.max

The specified possible maximum value of the attribute.

attribute.min

The specified possible minimum value of the attribute.

attribute.unit

The scientific unit for the attribute.

branch

Information about a node specified as a branch.

A group of signals that are defined in a hierarchical structure.

STRUCT(
    "fully_qualified_name" VARCHAR,
    "description" VARCHAR,
    "deprecation_message" VARCHAR,
    "comment" VARCHAR
)
Show child fields
branch.comment

A comment in addition to the description.

branch.deprecation_message

The deprecation message for the node or the branch that was moved or deleted.

branch.description

A brief description of the branch.

branch.fully_qualified_name

The fully qualified name of the branch. For example, the fully qualified name of a branch might be Vehicle.Body.Engine.

property

Represents a member of the complex data structure. The datatype of the property can be either primitive or another struct.

STRUCT(
    "fully_qualified_name" VARCHAR,
    "data_type" VARCHAR,
    "data_encoding" VARCHAR,
    "description" VARCHAR,
    "deprecation_message" VARCHAR,
    "comment" VARCHAR,
    "struct_fully_qualified_name" VARCHAR
)
Show child fields
property.comment

A comment in addition to the description.

property.data_encoding

Indicates whether the property is binary data.

property.data_type

The data type for the custom property.

property.deprecation_message

The deprecation message for the node or the branch that was moved or deleted.

property.description

A brief description of the custom property.

property.fully_qualified_name

The fully qualified name of the custom property. For example, the fully qualified name of a custom property might be ComplexDataTypes.VehicleDataTypes.SVMCamera.FPS.

property.struct_fully_qualified_name

The fully qualified name of the struct node for the custom property if the data type of the custom property is Struct or StructArray.

sensor

An input component that reports the environmental condition of a vehicle.

You can collect data about fluid levels, temperatures, vibrations, or battery voltage from sensors.

STRUCT(
    "fully_qualified_name" VARCHAR,
    "data_type" VARCHAR,
    "description" VARCHAR,
    "unit" VARCHAR,
    "allowed_values" VARCHAR[],
    "min" DOUBLE,
    "max" DOUBLE,
    "deprecation_message" VARCHAR,
    "comment" VARCHAR,
    "struct_fully_qualified_name" VARCHAR
)
Show child fields
sensor.allowed_values[]
sensor.comment

A comment in addition to the description.

sensor.data_type

The specified data type of the sensor.

sensor.deprecation_message

The deprecation message for the node or the branch that was moved or deleted.

sensor.description

A brief description of a sensor.

sensor.fully_qualified_name

The fully qualified name of the sensor. For example, the fully qualified name of a sensor might be Vehicle.Body.Engine.Battery.

sensor.max

The specified possible maximum value of the sensor.

sensor.min

The specified possible minimum value of the sensor.

sensor.struct_fully_qualified_name

The fully qualified name of the struct node for a sensor if the data type of the actuator is Struct or StructArray. For example, the struct fully qualified name of a sensor might be Vehicle.ADAS.CameraStruct.

sensor.unit

The scientific unit of measurement for data collected by the sensor.

struct

Represents a complex or higher-order data structure.

STRUCT(
    "fully_qualified_name" VARCHAR,
    "description" VARCHAR,
    "deprecation_message" VARCHAR,
    "comment" VARCHAR
)
Show child fields
struct.comment

A comment in addition to the description.

struct.deprecation_message

The deprecation message for the node or the branch that was moved or deleted.

struct.description

A brief description of the custom structure.

struct.fully_qualified_name

The fully qualified name of the custom structure. For example, the fully qualified name of a custom structure might be ComplexDataTypes.VehicleDataTypes.SVMCamera.