ViewRepresentation
¶
Source code in docs_src/capo_glue/types/view_representation.py
dialect_version
instance-attribute
¶
dialect_version: NotRequired[ViewDialectVersionString]
The version of the dialect of the query engine. For example, 3.0.0.
is_stale
instance-attribute
¶
is_stale: NotRequired[NullableBoolean]
Dialects marked as stale are no longer valid and must be updated before they can be queried in their respective query engines.
validation_connection
instance-attribute
¶
validation_connection: NotRequired[NameString]
The name of the connection to be used to validate the specific representation of the view.
view_expanded_text
instance-attribute
¶
view_expanded_text: NotRequired[ViewTextString]
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:
-
Fully qualified identifiers:
SELECT * from table1 -> SELECT * from db1.table1
view_original_text
instance-attribute
¶
view_original_text: NotRequired[ViewTextString]
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.