documentationadd_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 |
Constant |
|---|---|---|---|---|
keyfield |
fieldref |
Required |
Can be multiple |
Variable |
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)