A list of fixed variables?

Matillion ETL
1

Hi.

 

Is there a list of fixed variables somewhere? I'm struggling to find it. For example a variable that returns the current project name, or a variable that just returns a timestamp.

 

Thanks,

 

- Rob

2

Hi, I've found this - https://documentation.matillion.com/docs/2943424#automatic-variables - however what I'm looking for is a unique ID that I can stamp on a file output. So either a datetime stamp, or just a unique job id. I tried job_id and task_id and neither did what I wanted.

3

OK and now I found this too - which has helped. https://documentation.matillion.com/docs/2711553

 

Define a date-time variable, call it dt, and give it a valid default date.

You can then use the variable as normal like this - ${dt.now()}