create view with two part identifiers instead of 3

Help
1

The problem I’m having

VIEWS (materialization) are created with 3 part identifiers.
Example of a dbt compiled code sql:

create view "schema_name"."view_name" as 
select ......... from "**database_name**"."schema_name"."table_name"

The context of why I’m trying to do this

we would need to skip the “database_name” from the view defintion. as have a process that copies definitions and moves across databases. is it possible?

what we need is without “database_name”,

create view "schema_name"."view_name" as 
select ......... from ."schema_name"."table_name"