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.
|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|