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:

{{ 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).