Presto Analytics : RAQL Extension to EMML Statements for Mashups : <snapshot>
<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:
*The specified mashable or mashup.
*The specified mashable and operation.
*A specified time period.
*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.
Copyright © 2006-2015 Software AG, Darmstadt, Germany.
Product LogoContact Support   |   Community   |   Feedback