set_primary_key¶
Type of operation: Metadata
Description¶
Declare the primary key of the output as consisting of one or more named columns.
All rows with the same value in this column (or these columns) will be considered part of the same resource. This is a low-level function that will generate confusing results if not used as part of a larger context. It is recommended to instead use ‘make_resource’ or ‘update_resource’ or ‘timechart’ to go from event to resource, and ‘make_event’ to go from resource to event shape.
Note that time columns can be used as part of a primary key, and this can be a useful trick to produce resources that contain only one interval each.
Usage¶
set_primary_key columnname_1, columnname_2, ...
Argument |
Type |
Optional |
Repeatable |
Restrictions |
|---|---|---|---|---|
columnname |
storable |
no |
yes |
column |
Accelerable¶
set_primary_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¶
set_primary_key device_uid
Sets the primary key designation of the output dataset as the ‘device_uid’ field.
Aliases¶
set_pksetpk(deprecated)