GET (Table Validation Execution Status) - Teradata Ecosystem Manager

Teradata® Ecosystem Manager API Reference

Product
Teradata Ecosystem Manager
Release Number
16.20
Published
December 2020
Language
English (United States)
Last Update
2020-12-23
dita:mapPath
loa1512743917841.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-3204
Product Category
Analytical Ecosystem

Status Code

A status code of 200 is returned on a successful completion. A non-200 status code is returned if an error occurs.

Example: Get Table Validation Execution Details

{
	"table_name": "t1",
	"database_name": "testing_db",
	"sync_flag": "N",
	"sync_condition": "Warning",
	"status": "Success",
	"metric_name": "ROWCOUNT",
	"metric_ts": "2018-09-28T17:44:48.204Z",
	"where_clause": "1=1",
	"validation_sql": "SELECT tt.ROWCOUNT  FROM (SELECT CAST(count(*) AS DECIMAL(38,0)) ROWCOUNT  FROM \"testing_db\".\"t1\" WHERE 1=1) tt",
	"servers": [{
			"server_name": "sdt208",
			"metric_value": "1"
		},
		{
			"server_name": "sdt986",
			"metric_value": "1"
		}
	]
}