dbt-utils¶

Tested version: 1.3.3 | Integration tested: Yes

dbt-utils is the most widely used dbt community package, providing generic tests, SQL helpers, and schema management utilities.

Dispatch configuration¶

dispatch:
  - macro_namespace: dbt_utils
    search_order: ['your_project_name', 'dbt', 'dbt_utils']

Macro compatibility¶

Legend: = supported on Fabric, = not supported on Fabric

Macros marked with (override) have a T-SQL-compatible override in this adapter. All other supported macros work without any adapter-specific override.

Generic tests¶

Macro	Status	Notes
`accepted_range`
`at_least_one`	(override)	Subquery requires column alias; uses `TOP 1` instead of `LIMIT 1`
`cardinality_equality`
`equal_rowcount`	(override)	Uses `FULL JOIN` with explicit `ON` clause; `COALESCE` for NULL-safe comparison
`equality`
`expression_is_true`	(override)	T-SQL boolean handling differences
`fewer_rows_than`	(override)	Uses `FULL JOIN` with explicit `ON` clause; `CASE` instead of `GREATEST()`
`mutually_exclusive_ranges`	(override)	T-SQL window function and boolean syntax
`not_accepted_values`
`not_constant`
`not_empty_string`	(override)	T-SQL string function syntax
`not_null_proportion`
`not_null_where`	(override)	T-SQL `WHERE` clause handling
`recency`
`relationships_where`	(override)	T-SQL subquery syntax
`sequential_values`	(override)	T-SQL requires table alias; uses `PARTITION BY` syntax
`unique_combination_of_columns`
`unique_where`	(override)	T-SQL `WHERE` clause handling

SQL helpers¶

Macro	Status	Notes
`date_spine`
`deduplicate`	(override)	Uses T-SQL `ROW_NUMBER()` pattern
`generate_series`	(override)	Uses T-SQL `generate_series()` function
`generate_surrogate_key`	(override)	Uses `HASHBYTES('md5', ...)` with T-SQL concat and cast
`get_column_values`
`get_filtered_columns_in_relation`
`get_query_results_as_dict`
`get_relations_by_pattern`
`get_relations_by_prefix`
`get_single_value`
`group_by`		T-SQL does not support positional `GROUP BY` (e.g., `GROUP BY 1, 2`)
`haversine_distance`
`nullcheck`
`nullcheck_table`
`pivot`
`safe_add`
`safe_divide`
`safe_subtract`
`star`
`union_relations`
`unpivot`
`width_bucket`	(override)	Implements bucket logic with T-SQL arithmetic (no native `WIDTH_BUCKET`)

Web macros¶

Macro	Status	Notes
`get_url_host`
`get_url_parameter`
`get_url_path`

Jinja helpers¶

Macro	Status	Notes
`log_info`
`pretty_log_format`
`pretty_time`
`slugify`

Schema cleanup (internal)¶

These macros are used for schema management, not typically called directly in models:

Macro	Status	Notes
`drop_old_relations`	(override)	Uses `sys.tables`/`sys.views` system views
`drop_schema_by_name`	(override)	Uses dbt's `drop_schema` API
`drop_schemas_by_prefixes`	(override)	Iterates schemas using T-SQL system catalog
`get_tables_by_pattern_sql`	(override)	Queries `INFORMATION_SCHEMA` with T-SQL-compatible pattern matching