Query Fields#

Datasets#

Basic Fields#

Name

Aliases

Description

Comparators

Sortable

created

N/A

ISO8601 timestamp when the dataset was created.

=, !=, <, <=, >=, >

True

created_by

N/A

User who created the dataset.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

True

dataset_id

id

A ds_ prefixed unique ID for the dataset.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

False

description

N/A

Freetext human-readable description of the dataset.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

False

device_id

N/A

The unique ID of the device which created the dataset, or null if created by a human user.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

False

metadata

N/A

Custom key-value pairs added by users to categorize the dataset.

Other - See (1)

False

modified

N/A

ISO8601 timestamp when the dataset was last modified.

=, !=, <, <=, >=, >

True

modified_by

N/A

User who last modified the dataset.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

False

name

N/A

A short name for this dataset.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

False

org_id

N/A

Org which owns the dataset.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

False

tags

N/A

Custom string tags added by users to categorize the dataset.

CONTAINS, NOT_CONTAINS

False

  1. Metadata queries require you to continue the field with .keyname, and the supported comparators depend on the type of the metadata value.

Entity References#

files[0] - Used to reference a file which belongs to a dataset

topics[0] - Used to reference a topic which belongs to any file in a dataset

Files#

Basic Fields#

Name

Aliases

Description

Comparators

Sortable

association_id

dataset_id, collection_id

Unique ID of the resource which the file belongs to.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

True

created

N/A

ISO8601 timestamp when the file was uploaded.

=, !=, <, <=, >=, >

True

created_by

N/A

User who uploaded the file.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

True

description

N/A

Freetext human-readable description of the file and its contents.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

False

device_id

N/A

The unique ID of the device which uploaded the file, or null if uploaded by a human user.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

False

file_id

id

Unique ID for the file.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

True

metadata

N/A

Custom key-value pairs added by users to categorize the file.

Other - See (1)

False

modified

N/A

ISO8601 timestamp when the file was last modified.

=, !=, <, <=, >=, >

True

modified_by

N/A

User who last modified the file.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

True

org_id

N/A

Org which owns the file.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

False

origination

N/A

String which describes the client and user which uploaded the file.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

False

relative_path

name, path

Full path to the file in the context of its associated resource.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

True

size

N/A

File size in bytes

=, !=, <, <=, >=, >

True

status

N/A

Lifecycle status of the file.

=, !=

False

tags

N/A

Custom string tags added by users to categorize the file.

CONTAINS, NOT_CONTAINS

False

upload_id

N/A

Unique ID of the upload transaction responsible for this file.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

False

uri

N/A

The URI of the file.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

False

  1. Metadata queries require you to continue the field with .keyname, and the supported comparators depend on the type of the metadata value.

Entity References#

dataset - Used to reference the one and only dataset a file belongs to

topics[0] - Used to reference a topic which belongs to a file

Topics#

Basic Fields#

Name

Aliases

Description

Comparators

Sortable

association_id

file_id

Unique ID of the resource which the topic belongs to.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

True

association_type

N/A

Type of the resource which the topic belongs to.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

True

created

N/A

ISO8601 timestamp when the topic was created.

=, !=, <, <=, >=, >

True

created_by

N/A

User who created the topic.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

True

end_time

N/A

Epoch nanosecond timestamp of the last message in the topic.

=, !=, <, <=, >=, >

True

message_count

N/A

The number of messages in the topic.

=, !=, <, <=, >=, >

True

metadata

N/A

Custom key-value pairs added by users to categorize the topic.

Other - See (1)

False

modified

N/A

ISO8601 timestamp when the topic was last modified.

=, !=, <, <=, >=, >

True

modified_by

N/A

User who last modified the topic.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

True

msgpaths

fields

Reference a single property within a complex topic, e.g. sensor.imu.x.

Other - See (2)

True

org_id

N/A

Org which owns the topic.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

False

schema_checksum

N/A

Deterministic checksum version of a schema.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

False

schema_name

N/A

Name of the schema used to serialize messages in the topic.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

False

schema_version

N/A

Monotonically increasing version of a schema.

=, !=, <, <=, >=, >

False

start_time

N/A

Epoch nanosecond timestamp of the first message in the topic.

=, !=, <, <=, >=, >

True

topic_id

id

Unique numeric ID for the topic.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

True

topic_name

name

Name for the topic.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

True

  1. Metadata queries require you to continue the field with .keyname, and the supported comparators depend on the type of the metadata value.

  2. Message paths follow entity reference syntax

Entity References#

dataset - Used to reference the one and only dataset a topic belongs to

file - Used to reference the one and only file a topic belongs to

msgpaths[topic_name.full.message.path] - Used to reference an individual field within a topic. msgpaths queries also require a property to be specified at the end, such as the min/mean/max: msgpaths[cpuload.load].mean > 0

Message Paths#

Basic Fields#

Name

Aliases

Description

Comparators

Sortable

canonical_data_type

N/A

Well-known (and simplified) data types, normalized across frameworks/technologies.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

False

created

N/A

ISO8601 timestamp when the message path was created.

=, !=, <, <=, >=, >

True

created_by

N/A

User who created the message path.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

True

data_type

N/A

‘Native’/framework-specific data type of the attribute at this path. E.g. ‘float32’, ‘uint8[]’, ‘geometry_msgs/Pose’, ‘string’.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

False

message_path

name, path, field

Dot-delimited path to an attribute within a topic datum record.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

True

message_path_id

id

Unique numeric ID for the message path.

=, !=, <, <=, >=, >

True

metadata

N/A

Custom key-value pairs added by users to categorize the topic.msgpath.

Other - See (1)

False

modified

N/A

ISO8601 timestamp when the message path was last modified.

=, !=, <, <=, >=, >

True

modified_by

N/A

User who last modified the message path.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

True

topic_id

N/A

Unique numeric ID for the topic to which this message path is associated.

=, !=, <, <=, >=, >

True

  1. Metadata queries require you to continue the field with .keyname, and the supported comparators depend on the type of the metadata value.

Pre-computed statistics for message paths can also be accessed via the metadata field, for example metadata.max and metadata.mean.

Entity References#

dataset - Used to reference the one and only dataset a message path belongs to

file - Used to reference the one and only file a message path belongs to

topic - Used to reference the one and only topic a message path belongs to

Events#

Basic Fields#

Name

Aliases

Description

Comparators

Sortable

created

created_at

ISO8601 timestamp when the event was created.

=, !=, <, <=, >=, >

True

created_by

N/A

User who created the event.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

True

description

N/A

Free-text description of the event.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

False

end_time

N/A

UTC timestamp of the end of the event.

=, !=, <, <=, >=, >

True

event_id

id

Unique ID for the event.

=, !=

False

metadata

N/A

Custom key-value pairs added by users to categorize the event.

Other - See (1)

False

modified

modified_at, updated_at

ISO8601 timestamp when the event was last modified.

=, !=, <, <=, >=, >

True

modified_by

N/A

User who last modified the event.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

True

name

event_name

Friendly name for the event.

=, !=, CONTAINS, NOT_CONTAINS, LIKE, NOT_LIKE

True

org_id

N/A

Org which owns the event.

=, !=

False

start_time

N/A

UTC timestamp of the start of the event.

=, !=, <, <=, >=, >

True

tags

N/A

Custom string tags added by users to categorize the event.

CONTAINS, NOT_CONTAINS

False