How to change the schema for PostgreSQL without affecting the Widget configuration

In Bold BI, widgets in dashboards won’t be affected when we’re adding any new column to the database server used in the data source. The same is applicable when you are removing/deleting any unused column from the PostgreSQL.

Please find the following Example for your reference

1. For instance, consider a table with 6 columns as follows.
   

   

2. Configure the Widgets using the create data source.
   

   

3. We have done the widget configuration and published the dashboard.
   

   

4. Now we have made some changes in our database for which it was already configured in bold BI. For instance: Deleting a unused Column called “epocch” and adding a new column as “phone”
   

   

How to use the newly added database column in the widget configuration.

Usually, the data source will not automatically refresh the schema changes. For live mode, we need to edit the data source and execute it to get the changes from our PostgreSQL Server.

1. Now go to your configured dashboard in Bold BI, click on edit connection.
   

   

2. You’ll redirect to the dashboard designer page, click on the edit connection icon present at the left side data sources tab.
   

   

3. Click on the Run button to refresh the data sources.
   

   

4. Click update to get the data preview at the bottom
   

   

5. Now ensure all your data are reflected from the server and click on the Save button to proceed further.
   

   

6. You are all set. Now the designer page will re-render your data from the server without any loss in the widgets. Publish the widgets to save it.
   

   

7. Our Newly Configured dashboard will look like below, without any loss in data and widgets.
   

   

Additional References

• How to refresh data source fields in Bold BI when the underlying dataset schema changes?
• How to handle schema updates in Bold BI