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.

blockdiag object_at_data_source virtual_table consumer virtual_databases

Name

Description

object_at_data_source

A table, view, API call result, XML/JSON query result in tabular form

virtual_table

A relational model table that is a wrapper around the metadata from source system

consumer

Data consumer

virtual_databases

Virtual databases

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