I am trying to create a sequence in snowflake with max value and cycle.
However I am not able to find any document where it says how to provide the max value.
But again I see in doc it says Snowflake will throw error if threshold is reach.
Can somebody please suggest how to create the below sequence in snowflake.
create or replace sequence myseq as bigint
start with 10000
increment by 1
no min value
maxvalue 2000000
no cycle;
And If any body can suggest what is the max value of sequence in snowflake. If I create it without datatype.
Copyright Notice:Content Author:「danD」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/73529986/snowflake-sequence-max-value-and-cycle