View a markdown version of this page

AWS::Glue::Table ViewRepresentation - Amazon CloudFormation
SyntaxProperties
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

This is the new Amazon CloudFormation Template Reference Guide. Please update your bookmarks and links. For help getting started with CloudFormation, see the Amazon 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 Amazon 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