<snapshot>
Loads a dataset stream with the results of a query to the Presto Snapshots Repository. This dataset stream contains a collection of snapshots of results for:
![*](bullet.gif)
The specified mashable or mashup.
![*](bullet.gif)
The specified mashable and operation.
![*](bullet.gif)
A specified time period.
![*](bullet.gif)
A scheduled snapshot job.
This statement also implicitly creates the variable to hold the dataset stream.
You can also retrieve snapshots anonymously, without creating a named variable to hold the dataset stream, using
<raql>. See
Load Snapshot Data with <snapshot> or <raql> for examples.
Can Contain | Empty |
Allowed In | mashup | catch | else | elseif | for | foreach | if | macro | operation | sequence | try | while |
Attributes
Name | Required | Description |
name | yes | The name to assign to the variable to hold the snapshot collection from this query. This variable automatically is configured for streaming. |
query | yes | The query to execute to retrieve a collection of snapshots for a specific mashable or mashup, a specific mashable operation, a specific date and time or a specific snapshot job. This SQL query must include a where clause to identify the specific snapshots to include in this dataset. You can use the following columns in a snapshot query: service = the mashable or mashup ID for the snapshots to return. Note: | The ID for a mashable or mashup is different from the name. To find a mashable or mashup ID, open the mashable or mashup and click Show > Info. |
operation = the name of the operation for the snapshots to return. This is required if you use service and the mashable has multiple operations. createdtime = a timestamp when the snapshot was taken. job = the job ID for the snapshots taken by a scheduled snapshot job. |