If you wish to see metrics and details around a single column you can use the following API.
curl "https://<YOUR API ENDPOINT>/inspection/input/field/<YOUR DATA SOURCE ID>/<column name>/<data type>?onlyDistributions=true" \
-H 'Content-Type: application/json' \
-H 'Authorization: <YOUR API KEY>' \
|jq '[.fields[]]'
This will return the details of the column.
{ "distribution": [ { "value": "Technician", "count": 15 }, { "value": "Device", "count": 13 } ], "fillDistribution": [ { "value": 0, "count": 1 }, { "value": 1, "count": 28 } ], "recordFillDistribution": [ { "value": 0, "count": 1 }, { "value": 1, "count": 28 } ], "lengthDistribution": [ { "value": 6, "count": 13, "minValue": 6, "maxValue": 6 }, { "value": 10, "count": 15, "minValue": 10, "maxValue": 10 } ], "fieldType": "string", "availableSamples": [ { "operation": { "clazz": "UploadFileInput", "id": "6d0358d5-4ab5-40a6-8cfc-59df492168f6", "globalId": "6d0358d5-4ab5-40a6-8cfc-59df492168f6", "organizationId": "1b834115-5cd1-4939-897e-eda130dafdf8", "computeEnvironment": "b84e6e78-e26e-40a6-9890-00ddc3201136", "connectionPointer": "4c6dedaf-5878-4fcc-b82e-6bb2b5050cc3", "displayData": { "name": "test", "description": "", "creationTime": "2020-09-12T14:25:56.344935Z", "createdBy": "Yoni Iny (yoni@upsolver.com)", "modifiedTime": "2020-09-12T14:25:56.415150Z", "modifiedBy": "Yoni Iny (yoni@upsolver.com)", "versionId": "7f0f1c81-4e2f-48cc-9078-8da02cd4e357" }, "contentType": { "clazz": "CsvContentType", "inferTypes": false, "header": "a,b,c,d,e,f,g,h,i", "delimiter": ",", "nullValue": "\\N", "nestedJsons": [], "keepOriginalNestedJsonString": false, "headers": [ "a", "b", "c", "d", "e", "f", "g", "h", "i" ] }, "startExecutionFrom": "2020-09-12T14:23:00Z", "folder": "uploads/d967c7c8-2d87-4154-a455-4fdbcb582048", "isDeleted": false, "version": 48, "workspaces": [], "previewId": "d5a4c870ad88e4f886a0ec2a95bb175d", "executionParallelism": 1, "status": { "clazz": "Running" }, "safeStartTime": "2020-09-12T14:23:00Z" }, "samples": [] } ], "lastUpdate": "2020-09-22T21:22:00Z", "knownTotalValues": 28, "distinctValuesCount": 2, "maximumDistinctValuesCount": 1000, "stringRange": { "min": "Device", "max": "Technician" }, "seen": { "first": "2020-09-12T14:23:00Z", "last": "2020-09-12T14:23:00Z" }, "resultTimeRange": { "startTime": "2020-09-12T14:23:00Z", "endTime": "2020-09-22T21:22:00Z" }, "totalRows": 29, "hasMoreDistribution": false, "totalValues": 28, "fillRate": 0.9655172228813171 }
Comments
0 comments
Please sign in to leave a comment.