Skip to main content


vectorquery [query]



A query to run on the index. (type: string)



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)


A boolean value of true/false that determines whether or not to use the cache. Generally most commands will default to true.


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}$


CAUTION. When true, will DELETE all vectors in the index.


A Pinecone credential to override the default one named 'pinecone' required by this command.


Enriches each result row with the previous row. The previous columns will be appended with a _previous.


A filter to run on the command results before completing the command. If not provided, no filter is run on the results.


Starts the stage as if it was a fresh query, so will not use any previous result.


Adds a populated random guid column.


Used to label a stage with a user provided label.


Override for the system max concurrent workers for a stage.


A filter to apply to the query.


When true, will include the metadata of the vectors in the results.


When true, will include the values of the vectors in the results.


The Pinecone index to query.


The namespace of the index to query.


When true, will return the raw results from the query.


The number of results to return.


Randomizes the stage hash, even if args and flags are the same.


Controls if a stats calculation is run on a stage after it completes.


A comma separated list of columns to include in the command results. If not provided, all columns will be included.


Each command has a default type, either "mapping" or "reducing". Some commands can operate as either, when "reducing" they will operate on all rows at once, when "mapping", they will operate on one row at a time.


Will rerun the stage until the provided expression is valid for the first line of results.