How do I retrieve INCREMENT for Sequences in snowflake?

Question

(select INCREMENT from TEST_DB.INFORMATION_SCHEMA.SEQUENCES

Why this is not working but it working in other properties retrieval

Answer 1

Increment is a reserved word, therefore you need to write your query as this:

select "INCREMENT" from TEST_DB.INFORMATION_SCHEMA.SEQUENCES