SnowDDL
Search…
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.

Links

Copy link
On this page
Schema
Usage notes
Links