New sweetness, new features! Some highlights below, but check out the CHANGELOG.md for a complete round up of the changes.
Features Highlights:
bootstrap
task: allows you to create skeleton schema.yml files for all your models. If a column is already documented in another model, we'll take it from there, if not we'll add a placeholder. NOTE: theaudit
task can also perform the bootstrap if you give it--bootstrap
as CLI argument ✨ - PR: #233, #239, #252- Auto enforce
unique
andnot_null
tests if you have a primary_key declared in the{{ config() }}
of your model. - PR: #203 - dbt-sugar now also supports Redshift databases (still mainly untested and experimental) - PR: #229
- dbt-sugar knows how to read
DBT_PROFILES_DIR
if that's the way you prefer to tell dbt where its profile lives. This is also the first contribution by a non-core maintainer. Thanks @smomni for the hard work (PR: #256) - dbt-sugar can preserve the comments you may have in your model descriptor files by using the
preserve_yaml_order
toggle in the sugar config (see docs: https://bitpicky.gitbook.io/dbt-sugar/installation-and-configuration/configuration/sugar-config#preserve_yaml_order) or via the--perserve-yaml-order
CLI flag.