Skip to main content

Data Engineering

Manage database objects and view persistence directly from the frontend.

View Persistence​

Manage persisted views: store the result of a view query, so you see table results without rerunning the (slow) query.

In the create form you define:

  • the source and target table;
  • the object and load type;
  • the level — determines the load order. If view B depends on view A, give A level 0 and B level 1; this way A is loaded first and the data stays up to date.

Database Objects​

View all database objects (created by a user or by Yres), with:

  • the current definition and version history (compare via the dropdowns; the button in the bottom left compares the current vs. previous definition);
  • dependencies (link icon): objects this object depends on and objects that depend on it. Click an object to highlight linked objects in large dependency trees.

Adding objects to a change​

Right-click an object in the tree for a context menu: add to a change with or without dependencies, with content, or delete an object with a change.