ViewRepresentation
A structure that contains the dialect of the view, and the query that defines the view.
Types
Properties
The dialect of the query engine.
The version of the dialect of the query engine. For example, 3.0.0.
The name of the connection to be used to validate the specific representation of the view.
The expanded SQL for the view. This SQL is used by engines while processing a query on a view. Engines may perform operations during view creation to transform ViewOriginalText to ViewExpandedText. For example:
The SELECT query provided by the customer during CREATE VIEW DDL. This SQL is not used during a query on a view (ViewExpandedText is used instead). ViewOriginalText is used for cases like SHOW CREATE VIEW where users want to see the original DDL command that created the view.