generate_schema_name.sql

{% macro generate_schema_name(custom_schema_name, node) -%}

    {%- set default_schema = target.schema -%}
    {# checks that no schema was predefined in project.yml or config
     or we are in the development environment #} 

    {%- if custom_schema_name is none or target.name =='default' -%}

        {{ default_schema }}

    {%- else -%}
    {# we are in production, use custom schema name from project #}
        {{ custom_schema_name | trim }}

    {%- endif -%}

{%- endmacro %}