Customize schema for Macros

Hello All, I’m new to dbt. I’m trying to deploy a Snowflake stored procedure via Macro in dbt Cloud. I’ve created a macro for the respective stored procedure and invoking the macro from project.yml(on-run-start:). It’s creating the stored procedure in Snowflake BUT in the default schema, not the one I would like it to be created. Please advise me on how to customize the schema for Macros??