Enhancement: Allow dbt_utils.star() except list to be an type of capitalization

[reidwil-jb]

Issue:

Recently, I ran into an issue when trying to exclude columns from my dbt model using dbt_utils.star. This was happening because my command wasn't correctly formatted.

example.sql

select
  {{ dbt_utils.star(from=ref('my_model'), except=["column_a", "column_b"])
...

Because of this, my model was returning column_a and column_b because jinja2's list comparison doesn't find column_a to equal COLUMN_A (which makes sense).

Solution:

Cast both the input and except list to lower:

{%- if col.column|lower not in except|lower -%}

dbt-utils/macros/sql/star.sql

Line 19 in 696cf26

{%- if col.column not in except -%}

---

Note this is for snowflake specifically but this change should will work for every dbt supportive sql flavor.