# Snowflake schemas in Object Explorer

**URL:** <https://forums.toadworld.com/t/snowflake-schemas-in-object-explorer/55090>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [April 12, 2022, 8:52pm UTC](https://forums.toadworld.com/t/snowflake-schemas-in-object-explorer/55090 "2022-04-12T20:52:19Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![m\_kalam](https://avatars.discourse-cdn.com/v4/letter/m/b19c9b/32.png) [@m\_kalam](https://forums.toadworld.com/u/m_kalam)\
**Post date:** [April 12, 2022, 8:52pm UTC](https://forums.toadworld.com/t/snowflake-schemas-in-object-explorer/55090/1 "2022-04-12T20:52:19Z")

</div>

Hello,  
Is there a way to show schemas in the object browser?  
Right now, I see the databases then tables, but I don't see schemas.

---

<div class="post-metadata">

**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\
**Post date:** [April 13, 2022, 1:05am UTC](https://forums.toadworld.com/t/snowflake-schemas-in-object-explorer/55090/2 "2022-04-13T01:05:28Z")

</div>

Welcome to the TDP forum on ToadWorld!

You should be able to see the schema name associated with your tables in the Object Explorer, per snap below...

 ![image](https://global.discourse-cdn.com/quest/original/2X/2/28e1042d9f4fec0635f392b77da5a3b5f1b7ad3a.png)

---

<div class="post-metadata">

**Author:** ![m\_kalam](https://avatars.discourse-cdn.com/v4/letter/m/b19c9b/32.png) [@m\_kalam](https://forums.toadworld.com/u/m_kalam)\
**Post date:** [April 13, 2022, 6:04pm UTC](https://forums.toadworld.com/t/snowflake-schemas-in-object-explorer/55090/3 "2022-04-13T18:04:03Z")

</div>

Hello,  
Thank you for the response. I do see that, but is there a way to show the unique list of schemas then expand the ones I'm interested in? I'm working on a database that has thousands of tables and it's not easy to navigate this way.

Toad for Oracle does that perfectly.

---

<div class="post-metadata">

**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\
**Post date:** [April 14, 2022, 7:22pm UTC](https://forums.toadworld.com/t/snowflake-schemas-in-object-explorer/55090/4 "2022-04-14T19:22:04Z")

</div>

Agree that Toad for Oracle does that nicely in that the Schema Browser has this built-in.

It would be nice to add an extra column to TDP's Object Explorer to indicate Schema name for SnowFlake tables, as can be done for some other data sources like SQL Server (e.g. right-click column header in Object Explorer and choose Options-\>Extra Columns).

However, I have an idea for a work-around involving filters that you might like. Simply define filter/s that only display objects with the desired schema name. See snaps below on how to do it. Hope this helps.

 ![image](https://global.discourse-cdn.com/quest/original/2X/8/8c2470aadfd1e42279c512857714eb0cdfb63b97.png)

 ![image](https://global.discourse-cdn.com/quest/original/2X/1/1cf2899c580595a347fac5c5d7a934a15a509cff.png)

---

<div class="post-metadata">

**Author:** ![mercier104\_000](https://avatars.discourse-cdn.com/v4/letter/m/8e8cbc/32.png) [@mercier104\_000](https://forums.toadworld.com/u/mercier104_000)\
**Post date:** [April 19, 2022, 8:49am UTC](https://forums.toadworld.com/t/snowflake-schemas-in-object-explorer/55090/5 "2022-04-19T08:49:47Z")

</div>

Which version of tdp do you use?

---

<div class="post-metadata">

**Author:** ![Roland.Rosso](https://avatars.discourse-cdn.com/v4/letter/r/90ced4/32.png) [@Roland.Rosso](https://forums.toadworld.com/u/Roland.Rosso)\
**Post date:** [August 30, 2022, 2:33pm UTC](https://forums.toadworld.com/t/snowflake-schemas-in-object-explorer/55090/6 "2022-08-30T14:33:18Z")

</div>

Hi, we are expanding our usage of Snowflake and many of our users want to keep using TDP. We have tested in 6.0.5 and I do not see a way in the options to add 'schemas' to Object Explorer. I see this option for SQL Server for instance.  
Is there already a feature request for this?  
If there isn't, can we enter one?

Thank you!

---

<div class="post-metadata">

**Author:** ![Roland.Rosso](https://avatars.discourse-cdn.com/v4/letter/r/90ced4/32.png) [@Roland.Rosso](https://forums.toadworld.com/u/Roland.Rosso)\
**Post date:** [September 8, 2022, 5:45pm UTC](https://forums.toadworld.com/t/snowflake-schemas-in-object-explorer/55090/7 "2022-09-08T17:45:04Z")

</div>

Can anyone comment on Snowflake Schemas being properly detected and included as tab in Object Explorer?

---

<div class="post-metadata">

**Author:** ![Julie\_Hyman](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/julie_hyman/32/13709_2.png) [@Julie\_Hyman](https://forums.toadworld.com/u/Julie_Hyman)\
**Post date:** [September 15, 2022, 5:39pm UTC](https://forums.toadworld.com/t/snowflake-schemas-in-object-explorer/55090/8 "2022-09-15T17:39:30Z")

</div>

Hi Roland,

We have captured this new change for Toad Data Point and are looking at updating this in our first release of 2023. I do not have an exact timeframe yet.

---

<div class="post-metadata">

**Author:** ![Roland.Rosso](https://avatars.discourse-cdn.com/v4/letter/r/90ced4/32.png) [@Roland.Rosso](https://forums.toadworld.com/u/Roland.Rosso)\
**Post date:** [September 19, 2022, 7:37pm UTC](https://forums.toadworld.com/t/snowflake-schemas-in-object-explorer/55090/9 "2022-09-19T19:37:44Z")

</div>

Thank you for the update!
