2024 Jul 10 8:45 AM
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.
2024 Jul 10 11:37 AM - edited 2024 Jul 10 12:37 PM
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.
2024 Jul 10 11:57 AM - edited 2024 Jul 10 12:01 PM
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,