Deploy macro functions to custom schemas

Help
1

How to deploy macro to schemas based on folder name? I tried like below. But it errors out.

models:
  portal_data_migration:
    # Config indicated by + and applies to all files under models/example/    
    staging:
      +schema: _STAGING
    cleansing:
      +schema: _CLEANSING
2

What do you mean by “deploy macro to schemas”? Macros are used to generate SQL which is used inside of models.