📄️ adapter
Wrap the internal database adapter with the Jinja object `adapter`.
📄️ as_bool
Use this filter to coerce a Jinja output into boolean value.
📄️ as_native
Use this filter to coerce Jinja-compiled output into its native python.
📄️ as_number
Use this filter to convert Jinja-compiled output to a numeric value..
📄️ builtins
Read this guide to understand the builtins Jinja variable in dbt.
📄️ config
Read this guide to understand the config Jinja function in dbt.
📄️ cross-database macros
Read this guide to understand cross-database macros in dbt.
📄️ dbt_project.yml context
The context methods and variables available when configuring resources in the dbt_project.yml file.
📄️ dbt_version
Read this guide to understand the dbt_version Jinja function in dbt.
📄️ debug
The `{{ debug() }}` macro will open an iPython debugger.
📄️ dispatch
dbt extends functionality across data platforms using multiple dispatch.
📄️ doc
Use `doc()` in description fields to reference docs blocks.
📄️ env_var
Incorporate environment variables using `env_var` function.
📄️ exceptions
Raise warnings and errors with the `exceptions` namespace.
📄️ execute
Use `execute` to return True when dbt is in 'execute' mode.
📄️ flags
The `flags` variable contains values of flags provided on the cli.
📄️ fromjson
Deserialize a JSON string into python with `fromjson` context method.
📄️ fromyaml
Deserialize a YAML string into python with `fromyaml` context method.
📄️ graph
The `graph` context variable contains info about nodes in your project.
📄️ info_schema
Use the `info_schema()` macro to reference dbt Information Schema tables in checks or with dbt show --inline.
📄️ invocation_id
The `invocation_id` outputs a UUID generated for this dbt command.
📄️ local_md5
Calculate an MD5 hash of a string with `local_md5` context variable.
📄️ log
Learn more about the log Jinja function in dbt.
📄️ model
`model` is the dbt graph object (or node) for the current model.
📄️ modules
`modules` Jinja variable exposes useful Python modules for operating on data.
📄️ on-run-end context
Use these variables in the context for `on-run-end` hooks.
📄️ packages.yml context
Use these context methods to configure dependencies in the packages.yml file.
📄️ print
Use the `print()` to print messages to the log file and stdout.
📄️ profiles.yml context
Use these context methods to configure resources in `profiles.yml` file.
📄️ project_name
Read this guide to understand the project_name Jinja function in dbt.
📄️ properties.yml context
The context methods and variables available when configuring resources in a properties.yml file.
📄️ ref
Read this guide to understand the ref Jinja function in dbt.
📄️ return
Read this guide to understand the return Jinja function in dbt.
📄️ run_query
Use the `run_query` macro to run queries and fetch results; learn when it runs against the warehouse during compilation and `dbt docs generate`, and how to scope side-effecting SQL with `flags.WHICH`.
📄️ run_started_at
Use `run_started_at` to output the timestamp the run started.
📄️ schema
The schema that the model is configured to be materialized in.
📄️ schemas
A list of schemas where dbt built objects during the current run.
📄️ selected_resources
Contains a list of all the nodes selected by current dbt command.
📄️ set
Converts any iterable to a sequence of iterable and unique elements.
📄️ source
Read this guide to understand the source Jinja function in dbt.
📄️ statement blocks
SQL queries that hit database and return results to your Jinja context.
📄️ target
The `target` variable contains information about your connection to the warehouse.
📄️ this
Represents the current model in the database.
📄️ thread_id
The `thread_id` outputs an identifier for the current Python thread.
📄️ tojson
Use this context method to serialize a Python object primitive.
📄️ toyaml
Used to serialize a Python object primitive.
📄️ var
Pass variables from `dbt_project.yml` file into models.
📄️ zip
Use this context method to return an iterator of tuples.