check this out: https://docs.snowflake.com/user-guide/cost-attributing#label-query-cost-attribution

Query cost for hierarchical queries

check this out: https://docs.snowflake.com/user-guide/cost-attributing#label-query-cost-attribution

Query cost for hierarchical queries