Snapshot Queries

Snapshot Queries

Queries to retrieve snapshots are SQL queries that require a Select, From and Where clause to define which snapshots to include in the dataset. You identify snapshots in the Where clause by one of these conditions:

service = 'mashable ID or mashup ID' for snapshots of results for mashables or mashups with one operation. See Load Snapshots in a Named Variable for an example.

service = 'mashable ID or mashup ID' and operation = 'operation ID' for snapshots of results for mashables that have multiple operations.

createdtime = datetime, date or time for snapshots based on a time period. See Choose Snapshots by a Time Period for an example.

job = 'job ID' for snapshots taken by a specific scheduled snapshot job. Job IDs include the mashable or mashup ID and the operation for that scheduled job plus the timestamp when the job was created. See Choose Snapshots for a Scheduled Job for an example.

You can, of course, use different operators to specify the conditions and functions as needed.