View a markdown version of this page

AWS::Glue::Table ViewRepresentation - AWS CloudFormation
SyntaxProperties

This is the new CloudFormation Template Reference Guide. Please update your bookmarks and links. For help getting started with CloudFormation, see the AWS CloudFormation User Guide.

AWS::Glue::Table ViewRepresentation

A structure that contains the dialect of the view, and the query that defines the view.

Syntax

To declare this entity in your CloudFormation template, use the following syntax:

JSON

{
  "Dialect" : String,
  "DialectVersion" : String,
  "ValidationConnection" : String,
  "ViewExpandedText" : String,
  "ViewOriginalText" : String
}

YAML

  Dialect: String
  DialectVersion: String
  ValidationConnection: String
  ViewExpandedText: String
  ViewOriginalText: String

Properties

Dialect

The dialect of the query engine.

Required: No

Type: String

Allowed values: REDSHIFT | ATHENA | SPARK

Update requires: No interruption

DialectVersion

The version of the dialect of the query engine. For example, 3.0.0.

Required: No

Type: String

Minimum: 1

Maximum: 255

Update requires: No interruption

ValidationConnection

The name of the connection to be used to validate the specific representation of the view.

Required: No

Type: String

Pattern: [\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF\t]*

Minimum: 1

Maximum: 255

Update requires: No interruption

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 ViewOriginalText to ViewExpandedText. For example:

  • Fully qualified identifiers: SELECT * from table1 -> SELECT * from db1.table1

Required: No

Type: String

Maximum: 409600

Update requires: No interruption

ViewOriginalText

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.

Required: No

Type: String

Maximum: 409600

Update requires: No interruption