16.20 - GET (Table Validation Execution Status) - Teradata Ecosystem Manager

Teradata® Ecosystem Manager API Reference

prodname
Teradata Ecosystem Manager
vrm_release
16.20
created_date
December 2020
category
Programming Reference
featnum
B035-3204-107K

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"
		}
	]
}