Auto-increment/identity column in Snowflake table loaded by Qlik Replicate

MiguelHathaway — Mon, 26 Jan 2026 21:26:37 GMT

I am loading data from a flat file (csv) into a Snowflake table using Qlik Replicate tool. In the Snowflake table, I have a column called "load_rec_num" to store something like ROWNUM of Oracle, that is, an auto incrementing numeric value as data is getting loaded.

I tried 3 approaches on "load_rec_num", all from inside Snowflake, but none is working :

created "load_rec_num" as an identity column
created a sequence and had column "load_rec_num" default to sequence.nextval : load_rec_num DEFAULT MY_SEQ.nextval
created "load_rec_num" with the autoincrement keyword : load_rec_num autoincrement start 1 increment 1

None of these worked for the data load operation. Data got loaded into the table (using the Qlik Replicate jobs) but the column value was NULL. However, when I run INSERT sqls on the same table, this column "load_rec_num" got populated with a number, but that is not what I am looking for.

Is there a way (either from inside Snowflake or by some transformation from inside Qlik Replicate task or by using SQLite statements inside Qlik Replicate) whereby the column "load_rec_num" can be automatically loaded with auto-incrementing number when the data load is happening from Qlik Replicate tool ?

MyAccountAccess Credit Card

topic Auto-increment/identity column in Snowflake table loaded by Qlik Replicate in QlikView

Auto-increment/identity column in Snowflake table loaded by Qlik Replicate