We have a requirement to initialize the value of ${run_history_id} variable to a particular number. Is there a way to do so?

Matillion ETL
1

We have a requirement to initialize the value of ${run_history_id} variable to a particular number. Is there a way to do so?

2

Hi @aryandaredevil​

Could you please elaborate on exactly where you would want to use the variable value?

3

Hi,

 

Actually we are migrating our solution to Matillion and we are already using Snowflake database. In the current solution, there is already a system generated value named as Run_id, being populated to keep track of daily loads.

 

In Matillion, we want to utilise ${run_history_id} to populate Run_id but don’t want to overlap it with the existing counter.