dbt-profiler¶

Tested version: 1.0.0 | Integration tested: Yes

dbt-profiler generates column-level profiling statistics (min, max, median, standard deviation, uniqueness, null rates) for any relation in your dbt project.

Dispatch configuration¶

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

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.

Measure macros¶

Macro	Status	Notes
`measure_avg`	✅ (override)	Handles `bit` columns via `CASE` expression (T-SQL `AVG` rejects booleans)
`measure_median`	✅ (override)	Uses `PERCENTILE_CONT` window function with `TOP 1` (T-SQL has no `MEDIAN()`)
`measure_std_dev_population`	✅ (override)	Uses T-SQL `STDEVP()` instead of `stddev_pop()`
`measure_std_dev_sample`	✅ (override)	Uses T-SQL `STDEV()` instead of `stddev_samp()`
`measure_is_unique`	✅ (override)	Returns `'TRUE'`/`'FALSE'` strings (T-SQL has no boolean type)
`measure_count`	✅
`measure_count_nulls`	✅
`measure_count_distinct`	✅
`measure_min`	✅
`measure_max`	✅
`measure_not_null_proportion`	✅

Type detection macros¶

Macro	Status	Notes
`is_numeric_dtype`	✅ (override)	Handles `tinyint`, `smallint`, `decimal`, `money`, `real`
`is_logical_dtype`	✅ (override)	Handles `bit` type
`is_date_or_time_dtype`	✅ (override)	Handles `time`, `smalldatetime`
`is_struct_dtype`	✅

Utility macros¶

Macro	Status	Notes
`assert_relation_exists`	✅ (override)	Uses `TOP 0` instead of `LIMIT 0`
`get_profile`	✅
`get_profile_table`	✅
`print_profile`	✅
`print_profile_docs`	✅
`print_profile_schema`	✅

Disabled integration test models¶

Model	Reason
`profile_struct`	BigQuery-only (uses STRUCT type not available in T-SQL)
`profile_over_time`	Incremental model, not needed for basic profiling validation