Tristan Handy jthandy
tconbeer
/ describe_table.sql
Created
February 8, 2019 23:15
dbt macro for descriptive statistics of a model
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| {% macro can_sum(field) %} | |
| {{return(field.dtype.lower() in ('integer', 'bigint', 'double precision', 'float', 'real', 'numeric', 'decimal'))}} | |
| {% endmacro %} | |
| {% macro can_percentile(field) %} | |
| {{return(field.dtype.lower() in ('integer', 'bigint', 'double precision', 'float', 'real', 'numeric', 'decimal', 'date', 'timestamp', 'timestamptz'))}} | |
| {% endmacro %} | |
| {% macro describe_model(model) %} | |
| {# Calculates descriptive statistics for each field in model. Model should be a |