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¶