ViewRepresentation
A structure that contains the dialect of the view, and the query that defines the view.
Contents
- Dialect
-
The dialect of the query engine.
Type: String
Valid Values:
REDSHIFT | ATHENA | SPARKRequired: No
- DialectVersion
-
The version of the dialect of the query engine. For example, 3.0.0.
Type: String
Length Constraints: Minimum length of 1. Maximum length of 255.
Required: No
- IsStale
-
Dialects marked as stale are no longer valid and must be updated before they can be queried in their respective query engines.
Type: Boolean
Required: No
- ValidationConnection
-
The name of the connection to be used to validate the specific representation of the view.
Type: String
Length Constraints: Minimum length of 1. Maximum length of 255.
Pattern:
[\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF\t]*Required: No
- ViewExpandedText
-
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
ViewOriginalTexttoViewExpandedText. For example:-
Fully qualified identifiers:
SELECT * from table1 -> SELECT * from db1.table1
Type: String
Length Constraints: Maximum length of 409600.
Required: No
-
- ViewOriginalText
-
The
SELECTquery provided by the customer duringCREATE VIEW DDL. This SQL is not used during a query on a view (ViewExpandedTextis used instead).ViewOriginalTextis used for cases likeSHOW CREATE VIEWwhere users want to see the original DDL command that created the view.Type: String
Length Constraints: Maximum length of 409600.
Required: No
See Also
For more information about using this API in one of the language-specific AWS SDKs, see the following:
