16.20 - GET (Table Validation Configuration Details) - 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 Configuration Details

{
	"database_name": "testing_db",
	"table_name": "t1",
	"validations": [{
		"syncRules": [{
			"metric_name": "ROWCOUNT",
			"metric_value": "5.00000",
			"sync_condition": "10"
		}],
		"servers": [{
				"server_name": "sd714",
				"db_user": "dbuser1"
			},
			{
				"server_name": "sd619",
				"db_user": "dbuser1"
			}
		],
		"validation_name": "StandAlone",
		"validation_type": "StandAlone",
		"schedule_cron": "0 7 * * *",
		"schedule_time_zone": "America/Los_Angeles",
		"created_ts": "2018-09-28T17:43:40.006Z",
		"where_clause": "1=1"
	}]
}