A query snapshot captures a data query at a moment in time. The data in the snapshot will remain fixed even if the original source dataset is updated until/unless it is refreshed manually or automatically.
You can refresh the resulting query snapshot manually or set up a refresh schedule. If you choose automatic refresh, the system will listen for changes to the original data, and will update the snapshot within the interval of time you select.
Snapshotting data in this fashion is only available for:
- Study datasets
- Assays that have been copied into a study
- User-defined SQL queries
Queries exposed by linked schemas
are not available for snapshotting.
Create a Query Snapshot
- Go to the query, grid, or dataset you wish to snapshot.
- Select (Charts/Reports) > Create Query Snapshot.
- Name the snapshot (the default name appends the word "Snapshot" to the name of the grid you are viewing).
- Specify Manual or Automatic Refresh. For automatic refresh, select the frequency from the dropdown. When data changes, the snapshot will be updated within the selected interval of time. Options:
- 30 seconds
- 1 minute
- 5 minutes
- 10 minutes
- 30 minutes
- 1 hour
- 2 hours
- If you want to edit the properties or fields in the snapshot, click Edit Dataset Definition to use the Dataset Designer before creating your snapshot.
- Be sure to save (or cancel) your changes in the dataset designer to return to the snapshot creation UI.
- Click Create Snapshot.
View a Query Snapshot
Once a query snapshot has been created it is available in the data browser
and at (Admin) > Manage Study > Manage Datasets
Edit a Query Snapshot
The fields for a query snapshot, as well as the refresh policy and frequency can be edited starting from the grid view.
- Select (Grid Views) > Edit Snapshot.
- You can see the name and query source here, but cannot edit them.
- If you want to edit the fields in the snapshot, (such as to change a column label, etc.) click Edit Dataset Definition to use the Dataset Designer. You cannot change the snapshot name itself. Be sure to save (or cancel) your changes in the dataset designer to return to the snapshot creation UI.
- Change the Snapshot Refresh settings as needed.
- Click Update Snapshot to manually refresh the data now.
- Click Save to save changes to refresh settings.
- Click Done to exit the edit interface.
The Edit Snapshot
interface also provides more options:
- Delete Snapshot
- Show History: See the history of this snapshot.
- Edit Dataset Definition: Edit fields and their properties for this snapshot. Note that you must either save or cancel your changes in the dataset designer in order to return to the snapshot editor.