Have tried the s_row_id method but have observed the following characteristics:
1. The next id value is auto incremented by 1000 each time and I'm not sure how to prevent this.
2. Severe warnings displayed in the console i.e Trying to commit data in Shared AM: RowIdAM. Shared AM should only contain read-only data.
Any expertise appreciated.