# Customize schema for Macros

**URL:** <https://discourse.getdbt.com/t/customize-schema-for-macros/10480>\
**Category:** Help\
**Created:** [October 24, 2023, 2:13pm UTC](https://discourse.getdbt.com/t/customize-schema-for-macros/10480 "2023-10-24T14:13:17Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![vishal27dec](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/vishal27dec/32/3145_2.png) [@vishal27dec](https://discourse.getdbt.com/u/vishal27dec)\
**Post date:** [October 24, 2023, 2:13pm UTC](https://discourse.getdbt.com/t/customize-schema-for-macros/10480/1 "2023-10-24T14:13:17Z")

</div>

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??