SnowDDL
Search
K
Comment on page

SEQUENCE

Config path: /<database>/<schema>/sequence/<name>.yaml
Example:
start: 1
interval: 1

Schema

  • start (int) - starting value for sequence (default: 1)
  • interval (int) - sequence step (default: 1)
  • comment (str)

Usage notes

  1. 1.
    Start is applied on creation of sequence only. Existing sequences always retain their current value.
  2. 2.
    All sequences must be created explicitly and assigned to default_sequence of relevant table columns. It helps to preserve sequence value when table must be re-created to apply changes which cannot be applied via ALTER TABLE.