Michele Martucci
11/08/2025, 3:11 PMkapa.ai
11/08/2025, 3:11 PMkapa.ai
11/08/2025, 3:11 PMhash.sql or macro blocks like {% macro hash( in your own project's macros/ directory and in the dbt_packages/ directory where dependencies are installed. 2. Check your dbt logs and error messages. If you see unexpected behavior or errors related to the hash macro, the logs may indicate which macro is being called and from which package. For example, if a macro is returning a binary type instead of the expected type, it may be due to an override. 3. Review macro dispatch order. If you are using dbt's dispatch feature, check your dbt_project.yml for any dispatch configuration that might affect which hash macro is used. This approach is supported by user experiences in the knowledge sources, where issues were traced back to overridden macros by searching for macro definitions and reviewing project/package code. For example, one user found that another package was overriding the hash macro, causing type issues, and resolved it by adjusting the dispatch order or removing the conflicting macro definition from their project or dependencies. This method is effective for identifying and resolving macro override issues in dbt projects using Elementary and other packages [see example here](https://slack.com/archives/C02CTC89LAX/p1735815549097269).