# How to clean orphaned schema (Snowflake specific)

**URL:** <https://discourse.getdbt.com/t/how-to-clean-orphaned-schema-snowflake-specific/5506>\
**Category:** Help\
**Created:** [December 7, 2022, 6:42am UTC](https://discourse.getdbt.com/t/how-to-clean-orphaned-schema-snowflake-specific/5506 "2022-12-07T06:42:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jlmeasy](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/jlmeasy/32/1423_2.png) [@jlmeasy](https://discourse.getdbt.com/u/jlmeasy)\
**Post date:** [December 7, 2022, 6:42am UTC](https://discourse.getdbt.com/t/how-to-clean-orphaned-schema-snowflake-specific/5506/1 "2022-12-07T06:42:26Z")

</div>

Hi,

I’m new to dbt and there’s a requirement to drop a snowflake schema if it is already orphaned in dbt. Do you have any suggestions on how to do it?

---

<div class="post-metadata">

**Author:** ![joellabes](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/joellabes/32/3980_2.png) [@joellabes](https://discourse.getdbt.com/u/joellabes)\
**Post date:** [December 9, 2022, 6:06am UTC](https://discourse.getdbt.com/t/how-to-clean-orphaned-schema-snowflake-specific/5506/2 "2022-12-09T06:06:34Z")

</div>

Have a look at [Clean your warehouse of old and deprecated models](https://discourse.getdbt.com/t/clean-your-warehouse-of-old-and-deprecated-models/1547) for some examples!

---

<div class="post-metadata">

**Author:** ![jlmeasy](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/jlmeasy/32/1423_2.png) [@jlmeasy](https://discourse.getdbt.com/u/jlmeasy)\
**Post date:** [December 12, 2022, 10:13pm UTC](https://discourse.getdbt.com/t/how-to-clean-orphaned-schema-snowflake-specific/5506/3 "2022-12-12T22:13:08Z")

</div>

thanks for that joellabes. do you know if dtb has custom\_schema instead of custom\_models?

---

<div class="post-metadata">

**Author:** ![joellabes](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/joellabes/32/3980_2.png) [@joellabes](https://discourse.getdbt.com/u/joellabes)\
**Post date:** [December 12, 2022, 10:14pm UTC](https://discourse.getdbt.com/t/how-to-clean-orphaned-schema-snowflake-specific/5506/4 "2022-12-12T22:14:55Z")

</div>

Do you mean [https://docs.getdbt.com/docs/build/custom-schemas](https://docs.getdbt.com/docs/build/custom-schemas)?