What is the DocumentData table used for?

David Registro shared this question 3 years ago
Answered

What is the DocumentData table used for?

It seems to be one of the largest tables in the Yellowfin DB.

Comments (1)

photo
1

The DocumentData table stores a lot of report related data. Not meta-data, actual data. Such as;


  • Cached report result sets (this includes cached report, and snapshots created at the report level) ,
  • Freehand SQL (used for virtual tables, custom query filters, freehand SQL reports) , Cached filter results from older releases (wenow store the filter results in different tables),
  • CSV reports.


If your table seems abnormally large, it's most likely due to cached report result sets.

More information on how to cache reports, and how it works see here.

To clear some of these cached reports see here.

Comments have been locked on this page!