data-dwh-dbt-project/macros/generate_schema_name.sql

/*
This macro is necessary to allow different models to automatically be generated
in schemas different than the default one for the target database.

To understand better, check:
- https://www.youtube.com/watch?v=AvrVQr5FHwk
- https://docs.getdbt.com/docs/build/custom-schemas
*/
{% macro generate_schema_name(custom_schema_name, node) -%}

    {%- set default_schema = target.schema -%}
    {%- set is_ci_execution = env_var("IS_CI_EXECUTION", "0") | int -%}
    {%- set ci_schema_name = env_var("CI_SCHEMA_NAME", "ci_default") -%}

    {%- if is_ci_execution == 1 -%} {{ ci_schema_name }}
    {%- elif custom_schema_name is none -%} {{ default_schema }}
    {%- else -%} {{ custom_schema_name | trim }}
    {%- endif -%}

{%- endmacro %}