A snapshot is a table in Toad Intelligence Central (TIC) consisting of the result set of a query, the stored SQL query, and the mapping information to the remote object. A snapshot is a copy of the data taken at a specific point in time. A snapshot is created by publishing data from a remote source (see Publish to Toad Intelligence Central).
Snapshots can be private, public, or shared with a list of users you specify.
Note: This feature is available in the Toad Data Point Professional edition only and requires access to a Toad Intelligence Central server.
You can refresh a snapshot to reflect the current data in the source table or tables. You can refresh a snapshot manually, schedule a single refresh, or schedule a periodic refresh.
To refresh a snapshot immediately
To specify/modify the snapshot refresh schedule
A snapshot uses a Shared Authentication key. However, you must be the snapshot owner or have Manage privileges to refresh a snapshot.
See Create/Drop Index for a TIC Object for information about creating indexes in a snapshot.
Use the following operations (commands) from the Object Explorer toolbar or the right-click menu.
|Click to modify sharing (visibility) options for the selected snapshot. Specify Sharing and Manage Privileges for Objects|
|Click to add or delete tags for the selected snapshot. Alter Tags|
|Click to refresh or to modify the refresh schedule of the selected snapshot.|
|Click to refresh the selected snapshot immediately.|
|Drops the selected snapshot.|
|Locks the selected snapshot. Lock and Unlock Objects|
|Unlocks the selected snapshot. Lock and Unlock Objects|
The owner of a snapshot or a user with Manage privileges can perform the following operations on the snapshot (if the snapshot is not locked):
To see a comparison of snapshot properties against other TIC objects, see Data Objects in Toad Intelligence Central.
Note: You can automate the task of refreshing a snapshot by using the Refresh Snapshot activity in Automation. See Use Database Automation Activities for more information.