Local tables

This view displays and allows all user-created local tables to be managed.

Local tables are usually created for caching the data in a local database engine and can be queried later by using a more advanced syntax (GROUP BY, HAVING, MAX, MIN, COUNT, etc). This reduces repeated calls to Veeva Vault for working with data which is not expected to change frequently and can be cached locally, for example for development and testing purposes.

The local table serves as a direct conduit for transferring any alterations to Veeva Vault. This includes updates, edits, and deletions made to the current object or document within Vault. The status bar displays the currently active object.

The database file where data for the local tables is stored is encrypted and can be read only by dqMan.

For more information about creating and querying local tables see querying local tables.

Menu Option	What It Does
Refresh	Refreshes the data in the selected table with the current data in Veeva Vault
Drop	Drops the selected local table
Load	Loads the data from the local table into the grid. The query for the local table (including all fields) is added to the query editor
Auto-refresh	Automatically refreshes the local table periodically, starting on the selected date and at the specified interval