# Connect AI Missing Tables and Columns

**URL:** <https://community.cdata.com/t/connect-ai-missing-tables-and-columns/39>\
**Category:** CData Connect AI\
**Tags:** question, metadata\
**Created:** [March 20, 2023, 2:39pm UTC](https://community.cdata.com/t/connect-ai-missing-tables-and-columns/39 "2023-03-20T14:39:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Om\_D](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/om_d/32/2031_2.png) [@Om\_D](https://community.cdata.com/u/Om_D)\
**Post date:** [March 20, 2023, 2:39pm UTC](https://community.cdata.com/t/connect-ai-missing-tables-and-columns/39/1 "2023-03-20T14:39:26Z")

</div>

I am trying to query my sources in CData Connect AI but they are running slow. They used to run instantly.

What can I do to return to the speed the queries were running with?

---

<div class="post-metadata">

**Author:** ![Om\_D](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/om_d/32/2031_2.png) [@Om\_D](https://community.cdata.com/u/Om_D)\
**Post date:** [March 20, 2023, 2:44pm UTC](https://community.cdata.com/t/connect-ai-missing-tables-and-columns/39/2 "2023-03-20T14:44:09Z")

</div>

Occasionally, the Metadata Cache can fill up causing issue with speed, performance, and causing issues that do occur originally.

Clearing the Metadata Cache can resolve these issues. Your connections, saved queries, and Derived Views will not be cleared.

To clear the cache for the data source you’re having issues with, please navigate to the connection on the Sources page. There should be an option to “Clear Metadata” near&nbsp;the **Delete** and **Save & Test** buttons. Please select this option to clear the data source’s cache and resolve any performance issues you may have faced.

 ![50b2608c-c97f-43c9-afa6-4395896d40b7.png](https://us1.discourse-cdn.com/cdata/original/2X/1/136a396ac3ae23254f99e3dd26b4842b8a8f3567.png)