Learn how to govern Snowflake roles, shares, and data movement without slowing delivery. Join our live webinar on controlling drift, permissions, and audit readiness.
Last updated: September 2, 2025
The typeAttribute tag specifies information about attributes you create with the createCompositeType change type.
Name | Type | Description | Requirement |
| String | Name of the attribute | Required |
| String | Name of the type the attribute will be associated with | Required |
String | Name of an existing collation to be associated with a column of a composite type, or with a range type | Optional |
databaseChangeLog:
- changeSet:
id: 1
author: itTest
changes:
- createCompositeType:
typeName: myType
typeAttributes:
- typeAttribute:
name: attr0
type: int
- typeAttribute:
name: Attr1
type: int
- typeAttribute:
name: ATTR2
type: text
collation: en_US
- typeAttribute:
name: att®3
type: line
- typeAttribute:
name: attribute 4
type: real
databaseChangeLog:
- changeSet:
id: 1
author: itTest
changes:
- createCompositeType:
typeName: myType
typeAttributes:
- typeAttribute:
name: attr0
type: int
- typeAttribute:
name: Attr1
type: int
- typeAttribute:
name: ATTR2
type: text
collation: en_US
- typeAttribute:
name: att®3
type: line
- typeAttribute:
name: attribute 4
type: real