CREATE VIRTUAL TABLE

Contents

CREATE VIRTUAL TABLE#

Creates a virtual table — a metadata-only table that maps to an object in a source system and is exposed through Querona without copying data. This statement is specific to Querona.

Syntax#

CREATE VIRTUAL TABLE virtual table name PHYSICAL physical table name ( column definition , ) CONFIGURATION provider configuration

Arguments#

virtual table name

The name of the virtual table within the virtual database.

PHYSICAL physical table name

The object in the source system that the virtual table maps to.

CONFIGURATION

Provider-specific configuration for the mapping.

See also