add_key

Type of operation: Metadata

Description

Add a candidate key to the output.

The candidate key describes a combination of columns that together identify a resource instance, and can be the target of a foreign key.

Usage

add_key keyfield_1, keyfield_2, ...

Argument

Type

Optional

Repeatable

Restrictions

keyfield

storable

no

yes

column

Accelerable

add_key is always accelerable if the input is accelerable. A dataset that only uses accelerable verbs can be accelerated, making queries on the dataset respond faster.

Examples

add_key cluster_uid, resource_uid

Adds a candidate key that says that cluster_uid plus resource_uid together uniquely identify the resource instance.

Aliases

  • addkey (deprecated)