Skip to content

Latest commit

 

History

History
92 lines (56 loc) · 3 KB

File metadata and controls

92 lines (56 loc) · 3 KB

Snowflake::Database::Database

Allows for the creation and modification of a Snowflake Database. https://docs.snowflake.com/en/user-guide/databases.html

Syntax

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

JSON

{
    "Type" : "Snowflake::Database::Database",
    "Properties" : {
        "Name" : String,
        "DataRetentionTimeInDays" : Integer,
        "MaxDataExtensionTimeInDays" : Integer,
        "DefaultDdlCollation" : String,
        "Comment" : String
    }
}

YAML

Type: Snowflake::Database::Database
Properties:
    Name: String
    DataRetentionTimeInDays: Integer
    MaxDataExtensionTimeInDays: Integer
    DefaultDdlCollation: String
    Comment: String

Properties

Name

Specifies the identifier for the database; must be unique for your account.

Required: Yes

Type: String

Update requires: Replacement

DataRetentionTimeInDays

Specifies the number of days for which Time Travel actions can be performed on the database.

Required: No

Type: Integer

Update requires: No interruption

MaxDataExtensionTimeInDays

The maximum number of days for which Snowflake can extend the data retention period for tables in the database.

Required: No

Type: Integer

Update requires: No interruption

DefaultDdlCollation

Specifies a default collation specification for all schemas and tables added to the database

Required: No

Type: String

Update requires: No interruption

Comment

Specifies a comment for the database.

Required: No

Type: String

Update requires: No interruption

Return Values

Ref

When you pass the logical ID of this resource to the intrinsic Ref function, Ref returns the Name.