title: DBT to add comments to snowflakes columns
body: <p>We use DBT for ELT in snowflake. Want to add comments to each column in Snowflake. Either using COMMENT or ALTER command after every full refresh.</p>
  <p>Decided to add macros with commands and call it under on-run-end hook.</p>
  <pre><code>{​​​​​​​% macro comment_transactions_master() %}​​​​​​​
  
      {% if execute %}
          (COMMENT ON COLUMN 
          &quot;DEV_SCHEMA&quot;.&quot;DBT_TEMP&quot;.&quot;TR_MASTER&quot;.&quot;TR_ID&quot; IS 'testing comment';​​​​​​​)
      {% endif %}
  
  {​​​​​​​% endmacro %}​​​​​​​
  </code></pre>
  <p>Since there are 100+ columns and I am new to DBT, is there a better way to perform this operation?</p>