Virtual tables and views#

Virtual table is a metadata-only construct, that emulates relational table by wrapping around an existing object from the source system, for example, a table in CRM, ERP or an API call result. Behind the scenes, queries and updates on a virtual table invoke calls to the objects that virtual table wraps.

View is a stored query that is computed on demand. Views in Querona function like views in a DBMS. The only distinction is that when views are materialized in Querona, data resulting from the view execution are stored in the DMBS that backs the virtual database the view resides in.

To learn more please check the User’s Guide articles about Tables and Views.