Bruin CLI

Appearance

Filters ​

Bruin supports Jinja filters to modify any given variable before they are converted to string. Filters are separated from the variable by a pipe symbol (|) and may have optional arguments in parentheses. Multiple filters can be chained. The output of one filter is applied to the next.

sql
SELECT * 
FROM my_table 
WHERE dt BETWEEN '{{ start_date |  date_format('%Y-%m-%d') }}' 
             AND '{{ end_date | date_format('%Y-%m-%d') }}'

Default Filters ​

Bruin CLI supports various default filters supported by Jinja, you can see the list here.

Date Filters ​

Bruin supports various date-related filters to format dates that can be chained together.

add_days ​

Adds the given number of days to the date.

jinja
{{ end_datetime | add_days(3) }}

add_hours ​

Adds the given number of hours to the date.

jinja
{{ end_datetime | add_hours(3) }}

add_minutes ​

Adds the given number of minutes to the date.

jinja
{{ end_datetime | add_minutes(3) }}

add_seconds ​

Adds the given number of seconds to the date.

jinja
{{ end_datetime | add_seconds(3) }}

add_milliseconds ​

Adds the given number of milliseconds to the date.

jinja
{{ end_datetime | add_milliseconds(3) }}

date_add ​

CAUTION

The date_add filter is deprecated. Please use the add_days filter instead for better compatibility and consistency.

Adds given number of days to the date.

jinja
{{ end_datetime | date_add(3) }}

For a given datetime 2022-02-07T04:00:00.948740Z, this results in the following string:

2022-02-10T04:00:00.948740Z

You can also give negative numbers to subtract days.

date_format ​

Formats the date according to the given format string.

jinja
{{ end_datetime | date_format('%Y-%m-%d') }}

For a given datetime 2022-02-07T04:00:00.948740Z, this results in the following string:

2022-02-07

The format given here follows Python date formatting rules, you can see the list here.