extract
extract [column]
Extracts keys and values from the provided column containing stringified JSON
arguments:​
column
​
The column to extract from (should contain stringified JSON). (type: string
)
examples:​
Query​
echo '{"key": "value"}'
|| extract echo
Results prior to extract stage:​
key |
---|
| {"key": "value"}
Results after extract stage:​
key |
---|
value |
flags:​
--appendStage
​
Used to append the results from a previous stage to the current stage. (provide a label, stage index, or boolean true to append the previous results)
--cache
​
A boolean value of true/false that determines whether or not to use the cache. Generally most commands will default to true.
--checkpoint
​
Format: "{CHECKPOINT NAME}:{COLUMN}" Used to store the value of the provided column (in the first row of results) in the provided name for use as a checkpoint in scheduled queries or other stages. Can be accessed using $CHECKPOINTS.{CHECKPOINT NAME}$
--filter
​
A filter to run on the command results before completing the command. If not provided, no filter is run on the results.
--guid
​
Adds a populated random guid column.
--labelStage
​
Used to label a stage with a user provided label.
--randomizeHash
​
Randomizes the stage hash, even if args and flags are the same.
--stats
​
Controls if a stats calculation is run on a stage after it completes.
--table
​
A comma separated list of columns to include in the command results. If not provided, all columns will be included.
support​
AMI_ENTERPRISE
AMI_FREE
AMI_PRO
BINARY_ENTERPRISE
BINARY_FREE
BINARY_PRO
DESKTOP_ENTERPRISE
DESKTOP_FREE
DESKTOP_PRO
DOCKER_ENTERPRISE
DOCKER_FREE
DOCKER_PRO