Refresh database schema
When your database schema changes, make sure those changes are reflected in Count.
Last updated
When your database schema changes, make sure those changes are reflected in Count.
Last updated
If the tables available to Count through its database credentials change, then you will need to ask Count to fetch the latest schema to see those changes reflected your workspace.
Database schema can be refreshed by workspace admins or above.
Select your connection from the workspace home page, then Manage connection. The option to refresh the schema is available near the bottom of the page.
If your database contains a large number of tables, Count may not import all of them. To reduce the number of tables that Count attempts to import, an optional filter may be applied that is applied to the schema of the table.
This filter should be in the form of a Javascript regular expression, and only schema which match this expression will be included. For example, to only fetch schema that begin with the text "production", the filter should be ^production
. To only fetch schema that end with the text "_prod", the filter should be _prod$
.
You can also refresh the schema directly from the canvas by clicking the refresh icon in the data bar.