Skip to main content
Solved

Connect Cloud Some Tables and Columns are missing and are not appearing

  • April 28, 2023
  • 1 reply
  • 116 views

Om D
Forum|alt.badge.img

I am using Connect AI to pull some data but I am missing some Tables and Columns that exist in the data source.

Where can I find them and what can I do to make sure that I am getting all of my data? 

Best answer by Om D

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

If you are missing tables or columns from that are in the data source or have added new tables and columns, clearing the metadata cache will force Connect AI to request the metadata again which will provide the most updated version of your data.

We do not cache the metadata for relational databases. If this case and you are missing tables and columns, please contact our Support Team at [email protected].

To clear the cache for your data source, please navigate to the connection on the Sources tab. There should be an option to "Clear Metadata". Please select this option to clear your account's cache and resolve any performance issues you may have faced.

 

This topic has been closed for replies.

1 reply

Om D
Forum|alt.badge.img
  • Author
  • Employee
  • Answer
  • April 28, 2023

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

If you are missing tables or columns from that are in the data source or have added new tables and columns, clearing the metadata cache will force Connect AI to request the metadata again which will provide the most updated version of your data.

We do not cache the metadata for relational databases. If this case and you are missing tables and columns, please contact our Support Team at [email protected].

To clear the cache for your data source, please navigate to the connection on the Sources tab. There should be an option to "Clear Metadata". Please select this option to clear your account's cache and resolve any performance issues you may have faced.