If omitted, the test will check for a numeric gap. This test supports the group_by_columns parameter; see Grouping in tests for details. unique_combination_of_columns (source) Asserts that the combination of co
In any event, that's ahorribleerror message. Ideally, we could wrap it in a helpful pointer to the failed-to-parse model name/file. The place where we catch Jinja templating errors is here: https://github.com/fishtown-analytics/dbt/blob/1eac726a07d4cdf8aa630573cd5476513dad2166/core/d...
See https://docs.getdbt.com/reference/dbt-jinja-functions/cross-database-macros. Jinja Helpers pretty_time (source) This macro returns a string of the current timestamp, optionally taking a datestring format. {#- This will return a string like '14:50:34' -#} {{ dbt_utils.pretty_time(...
{%- for prop in tblproperties -%} '{{ prop }}' = '{{ tblproperties[prop] }}' {% if not loop.last %}, {% endif %} {%- endfor %} ) {%- endif %} {%- endmacro -%} {% macro file_format_clause() %} {{ return(adapter.dispatch('file_format_clause', 'dbt')()) }} ...
See https://docs.getdbt.com/reference/dbt-jinja-functions/cross-database-macros. Jinja Helpers pretty_time (source) This macro returns a string of the current timestamp, optionally taking a datestring format. {#- This will return a string like '14:50:34' -#} {{ dbt_utils.pretty_time(...
If omitted, the test will check for a numeric gap. This test supports the group_by_columns parameter; see Grouping in tests for details. unique_combination_of_columns (source) Asserts that the combination of columns is unique. For example, the combination of month and product is unique, ...
This macro is useful for transforming Jinja strings into "slugs", and can be useful when using a Jinja object as a column name, especially when that Jinja object is not hardcoded. For this example, let's pretend that we have payment methods in our payments table like ['venmo App', 'ca...