Snapshots in TIC
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 Studio Professional edition only and requires access to a Toad Intelligence Central server.
Refreshing a Snapshot
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
- Select the snapshot in the Object Explorer and click
.
To specify/modify the snapshot refresh schedule
- Use one of the following methods to specify refresh schedule options:
- In the Object Explorer, right-click a snapshot and select Operations | Schedule Refresh Snapshot.
- In the Object Explorer, select a snapshot and click
.
- To schedule a recurring refresh, specify the Schedule Recurring Refresh options.
- To delay the start of the recurring refresh, select a date in the Range of Recurrence options.
Access to Snapshots
A snapshot uses a Shared Authentication key. However, you must be the snapshot owner or have Manage privileges to refresh a snapshot.
Create Snapshot Index
See Create/Drop Index for a TIC Object for information about creating indexes in a snapshot.
Operations
Use the following operations (commands) from the Object Explorer toolbar or the right-click menu.
| Operation | Description |
|---|---|
 |
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 |
Snapshot Manage Privileges
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):
- Refresh a snapshot
- Lock a snapshot
- Drop a snapshot
- Rename the snapshot
- Modify the snapshot sharing options
- Modify snapshot refresh schedule
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. Use Database Automation Activities