AWS::Athena::PreparedStatement - Amazon CloudFormation
SyntaxPropertiesReturn values
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).

AWS::Athena::PreparedStatement

Specifies a prepared statement for use with SQL queries in Athena.

Syntax

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

JSON

{
  "Type" : "AWS::Athena::PreparedStatement",
  "Properties" : {
      "Description" : String,
      "QueryStatement" : String,
      "StatementName" : String,
      "WorkGroup" : String
    }
}

YAML

Type: AWS::Athena::PreparedStatement
Properties: 
  Description: String
  QueryStatement: String
  StatementName: String
  WorkGroup: String

Properties

Description

The description of the prepared statement.

Required: No

Type: String

Minimum: 1

Maximum: 1024

Update requires: No interruption

QueryStatement

The query string for the prepared statement.

Required: Yes

Type: String

Minimum: 1

Maximum: 262144

Update requires: No interruption

StatementName

The name of the prepared statement.

Required: Yes

Type: String

Minimum: 1

Maximum: 256

Pattern: [a-zA-Z_][a-zA-Z0-9_@:]{1,256}

Update requires: Replacement

WorkGroup

The workgroup to which the prepared statement belongs.

Required: Yes

Type: String

Update requires: Replacement

Return values

Ref

When you pass the logical ID of this resource to the intrinsic Reffunction, Refreturns the name of the prepared statement.

For more information about using the Reffunction, see Ref.