Variables
Accessing variables in Mage
Variables
Accessing variables in Mage
You've got all of these great variables and secrets, now let's put them to use. Learn how to access them in your code. 🦸🏻♂️
Mage allows users to interpolate variables specific to your pipeline or project. The following syntax is specific to yaml and SQL files.
Here’s a list of the different variables and functions you can use in your code:
| Syntax | Description |
|---|---|
{{ env_var('secret') }} | Get secret from environment variables. |
{{ variables('secret') }} | Get secret from runtime variables. |
{{ mage_secret_var('secret') }} | Get secret from Mage secrets. |
{{ aws_secret_var('secret') }} | Get secret from AWS Secrets Manager. |
{{ azure_secret_var('secret') }} | Get secret from Azure Key Vault. |
{{ json_value(json_obj, 'key') }} | Extract value from a JSON string. |
{{ n_days_ago(N) }} | Get the date N days ago (data integration pipelines only). |