sql_header does not support Jinja + macros

[dbeatty10]

Contributions

• I have read the contribution docs, and understand what's expected of me.

Link to the page on docs.getdbt.com requiring updates

https://docs.getdbt.com/reference/resource-configs/sql_header

What part(s) of the page would you like to see updated?

As mentioned here, Jinja + macros (including ref + source) will not work as expected inside of sql_header. This is different than pre/post-hooks which do support Jinja + macros (by "late rendering" them).

This should be some kind of highlighted warning/note in the docs.

The note could read something like the following:

Unlike pre-/post-hooks, macros like ref and source and references like {{ this }} are not supported.

An option is to include commentary like:

The intended purpose of set_sql_header is quite narrow: creating UDFs, setting script variables (BQ), setting temporary session parameters (Snowflake), etc.

Additional information

No response