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)