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 ...

Argument

Type

Required

Multiple

keyfield

fieldref

Required

Can be multiple

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)