# Badge\_posts in Data Explorer

**URL:** https://meta.discourse.org/t/badge-posts-in-data-explorer/245509
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [November 14, 2022, 11:31am UTC](https://meta.discourse.org/t/badge-posts-in-data-explorer/245509 "2022-11-14T11:31:40Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Anai-s](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/anai-s/32/255759_2.png) [@Anai-s](https://meta.discourse.org/u/Anai-s)
#### Post date: [November 14, 2022, 11:31am UTC](https://meta.discourse.org/t/badge-posts-in-data-explorer/245509/1 "2022-11-14T11:31:40Z")

</div>

Hi everyone,  
Do you know why I can’t see the data from the table **badge\_posts** in [Data Explorer](https://meta.discourse.org/t/32566?silent=true)? The weird thing is that I can run a query from this table but not see it.

 ![image](https://global.discourse-cdn.com/meta/original/4X/7/8/3/783b4c646e7459be7695794b1a31b2187a4c06fc.png)

---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [November 14, 2022, 1:14pm UTC](https://meta.discourse.org/t/badge-posts-in-data-explorer/245509/2 "2022-11-14T13:14:32Z")

</div>

I have actually wondered this myself a couple of times, so I went and asked a clever person. 🙂

Apparantly:

> It’s technically a Postgres ‘view’ rather than a table
> 
> You should still be able to query it, but it won’t be included in the auto-generated tree of tables/columns