# target db/schema and profile is hidden or uncomprehending

**URL:** <https://discourse.getdbt.com/t/target-db-schema-and-profile-is-hidden-or-uncomprehending/20218>\
**Category:** Help\
**Tags:** jinja, best-practice, snowflake, dbt-cloud, macros\
**Created:** [September 9, 2025, 11:39pm UTC](https://discourse.getdbt.com/t/target-db-schema-and-profile-is-hidden-or-uncomprehending/20218 "2025-09-09T23:39:34Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Fhashmi](https://avatars.discourse-cdn.com/v4/letter/f/dc4da7/32.png) [@Fhashmi](https://discourse.getdbt.com/u/Fhashmi)\
**Post date:** [September 9, 2025, 11:39pm UTC](https://discourse.getdbt.com/t/target-db-schema-and-profile-is-hidden-or-uncomprehending/20218/1 "2025-09-09T23:39:34Z")

</div>

## The problem I’m having can be explained by the attached screenshots. The profile in the dbt\_project.yml is default. While there is a macro that decides which DB and schema is chosen for building the objects in. The problem is where is this macro(get\_custom\_database) registered to be executed when I build or run my .sql. Simply what is the execution lifecycle of dbt cloud. Lastly when we run dbt projects in snowflake, does the execution and code get executed in dbt or snowflake first?

 ![dbt_project](https://us1.discourse-cdn.com/flex020/uploads/getdbt/original/2X/a/ade87b75fb2f11186f7725ca5b30f5385d1579da.png)

## The context for this is to find out if I stop developing in dbt cloud and do development in snowflake do i need dbt account.

## I’ve not tried to change anything since the same things are in deployment in both prod and dev environemnts.

## Some example code or error messages

```auto
Put code inside backticks
  to preserve indentation
    which is especially important 
      for Python and YAML! 

```