Data and Analytics Discussions
Get involved in Data & Analytics discussions. Engage in vibrant conversations, share insights, and explore perspectives on data and analytics topics.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Remote tables statistics, can be read?

XaviPolo
Active Contributor
0 Kudos
867

In the Data Integration Monitor we can create statistics of the remote sources, but is there any way to see the results in DSP?

I can't get access to the tables where the data is supposed to be stored.
In "SYS". "DATA_STATISTICS" there are the fields that have been analyzed but not the results, like maximum, minimum value, etc.

any idea how to do it?

Thx in advance.


XP,

Seidor - Human Focused, Technology Experts
2 REPLIES 2
Read only

XaviPolo
Active Contributor
0 Kudos
813

I answer myself.

SYS.M_DATA_STATISTICS -> results are in a LargeString field, in json format.

UPDATED: at least for Google Big Query data sources, the MAX VALUE and MIN VALUE statistics are wrong or I don't undestand the results 😞
MAX and MIN VALUES in theory are the size in bytes of the max and min values for the column and for an INT field I'm getting values like 13510798882111488 -> 13.5 TeraBytes, when the values of the colums are from 0 to 999.



XP,

Seidor - Human Focused, Technology Experts
Read only

XaviPolo
Active Contributor
797

Hi esther598, 

Let me be frank, my question is very specific, how to access the data that creates the statistics, and these answers from ChatGPT, besides not answering my question, wastes our time.

I hope that the community managers, do something about this issue of AI generated answers that in most cases are not correct and only serve to confuse and to feed the next version of AI models with incorrect data generated by themselves :-(.

Regards,


XP,

Seidor - Human Focused, Technology Experts