By default, all assets are built in the schema/dataset specified in the Branch environment. Each branch can be configured to write to its own schema and dataset.
You can now build assets in schemas and databases other than the default schema and database set in the Branch environments settings page.
{{ config(schema='staging_schema') }}
select ...
models:
y42_project:
staging:
+materialized: view
+schema: staging # Assets in `models/staging/ will be built in the "<branch_name>_staging" schema.
mart:
+schema: mart # Assets in `models/mart/ will be built in the "<branch_name>_mart" schema.
# All other assets will be built in the "<branch_name>" schema.