New Webinar: Govern roles, shares, and data movement in Snowflake

Learn how to govern Snowflake roles, shares, and data movement without slowing delivery. Join our live webinar on controlling drift, permissions, and audit readiness.

Save your spot

addAttribute

Last updated: September 2, 2025

The addAttributes tag specifies information about attributes you create with the alterCompositeTypeAttributes change type.

Available attributes

Name

Type

Description

Requirement

name

String

Name of the composite type attribute to be created.

Required

type

String

Name of the type the attribute will be associated with.

Required

collation

String

Name of an existing collation to be associated with a column of a composite type, or with a range type

Optional

onCreate

String

Set to CASCADE or RESTRICT. CASCADE automatically updates objects that depend on the type. RESTRICT does not update the type if any objects depend on it. Default: RESTRICT.

Optional

addAttribute examples

loading