Hello and happy Wednesday!
I have some new data that was imported into SNOW from another source that has an "ID" field with a unique sequential number assigned to each record. For instance, a record with a "Name" of "George" has an "ID" of 5, and was the 5th record generated on the old source. The "Name" and "ID" field are just simple String type.
I've been asked to find a way to add the next sequential number to the ID field when creating a new record for this app. So, if the last record has an ID of 499, if I create a new record it will automatically be assigned an ID 0f 500.
Any tips on how to realize this?
