Reloading the database schema
Last updated
Last updated
Datawisp only connects to your database when the user uses the data. Therefore Datawisp is not automatically informed when you create, change or delete tables or views.
This means that sometimes the schema of your database, and the schema that Wispy or you see is different. To resolve this, it is recommended that you reload the schema after:
You create or delete a table or a view
You alter the schema of a table or a view by adding or removing columns, or changing their type
You change the permissions for tables or views that are imported into Datawisp.
First, navigate to the data page by clicking on the "Data" button on the left.
Then, for the data source that changed, click the three dots on the very right:
And last, click on "Reload schema" in the menu:
Leave the Datawisp tab open until the process is finished. Usually, this takes less than thirty seconds, but in rare cases this can take up to 10 minutes, depending on the size of your database schema.
Once it is done, the "Modified" date of the data source should be the current time, you can also validate that the changes to the schema are visible in Datawisp.
If the schema has changed, it is often sensible to update the data dictionary. You can update individual tables, or all tables at once by clicking "Generate data dictionary" in the same menu:
If you already have an existing data dictionary, you have two choices:
You can overwrite your current data dictionary - in that case, all manual changes you've made to the data dictionary will be lost.
You can keep your changes - in that case, only newly added tables and/or columns will be described by the AI. Already existing entries in the data dictionary will not be touched.
If you know exactly what tables changed, it's often faster to just update the data dictionary for those tables. In that case, open up the data dictionary for that specific table:
There, you can press the "Generate with AI" button.