Managing the workspace schema cache

You can configure a workspace to cache the source database schema, to reduce the number of times that Tonic Structural needs to query the source database.

Viewing the schema cache status

When schema caching is enabled for a workspace, then in the expanded version of the workspace management view header, below the workspace name, Structural shows the current status of the schema cache.

Schema cache status for a workspace

The status indicates when:

• Structural is retrieving the schema information.

• Structural is checking for schema updates.

• Structural is refreshing the schema cache.

• Structural fails to connect to the source database.

• The schema cache refresh fails.

• The schema cache is updated. The status includes the timestamp of the most recent refresh.

Refreshing the schema cache

When the schema cache is updated, or when Structural has detected updates to the schema, then the schema cache status includes an option to refresh the schema cache.

Refresh Schema option for a workspace schema cache

To refresh the schema:

1. Click the schema cache status.

2. On the panel, click Refresh Schema.

Structural starts a new schema retrieval job. To track the progress of the job, go to the workspace Jobs view.