I’m trying to create a sequence into Snowflake for a table ID, I need it to increase 1 by 1 (1,2,3,4,…), how ever when I create it and try sequence.nextval it increases (1,101,201,301…) and I don’t know why.

I’m using the next code to create the sequence (I’m using sysadmin and the correct database)

CREATE OR REPLACE SEQUENCE SEQ_AUTHOR_UID
    START WITH 1
    INCREMENT BY 1;
    COMMENT= 'Use this to fill in AUTHOR_UID';

Also I tried with:

CREATE SEQUENCE SEQ_AUTHOR_UID
    START = 1
    INCREMENT = 1
    COMMENT = 'Use this to fill in AUTHOR_UID';

enter image description here