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"