Hello Aginity Users,
I work for a company which allows only read-access to data tables.
I need to do some in-depth profiling of approx. 20 data tables containing approx. 25-40 columns each.
Can anyone point me in the direction of script which will allow me to interrogate the tables to provide some summary profiling/statistics e.g min/max values, most frequent values, nulls, distinct, count etc?
Because I only have read-access, I am unable to run anything which requires temporary tables, or utilises the Aginity inbuilt 'analyse' functions, as these features are not available to me.
Any help would be greatly appreciated.
Please sign in to leave a comment.