Build Single System View Instead of All

When adding a new check table to the System Views page, the only option for the 'Build' button is at the datasource level. It would be nice to have an option to build this automatically when you add a new check table. When you click '+' button and add your table there could be a drop-down to pick your datasource, and then the System View gets generated on your working db automatically.


The issue we have been having is if that if you have a database with many objects on it, it's not uncommon to have 300+ system views. Clicking the build button then drops all 300 views and recreates them, and if an object is running ETL at the same time they deadlock each other.


Another option would be to change the DROP/CREATE action to an ALTER VIEW, but I think it makes more sense to just build the view when you add the table - there's no need to affect 300 unrelated database objects for adding one new check table.

  • Peter Berke
  • Aug 2 2024
  • Attach files