16.10 - GET (Tables) - Teradata Ecosystem Manager

Teradata Ecosystem Manager API Reference

prodname
Teradata Ecosystem Manager
vrm_release
16.10
created_date
June 2017
category
Programming Reference
featnum
B035-3204-067K

Purpose

List of tables.

URL

/emrest/datadiscovery/databases/{database-name}/tables

HTTP Method

GET

Request Parameters

Query parameter:unity_managed [Optional]

Path variable: database-name

Response

An array of the following JSON.
Name Description Data Type
database_name Name of database String
table_name Name of table String
servers Servers list where database is located An array of JSON (Shown in Servers JSON Description table.)
Servers JSON Parameters
Name Description Data Type
server_name Name of server String
unity_managed Boolean indicating whether it is a Unity Managed table Boolean

Status

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

Example: List of Tables

[
    {
        "table_name": "emserver",
        "database_name": "emviews",
        "servers": [
            {
                "server_name": "falco",
                "unity_managed": false
            },
            {
                "server_name": "wario",
                "unity_managed": false
            }
        ]
    },
    {
        "table_name": "MSMEcosystem",
        "database_name": "emviews",
        "servers": [
            {
                "server_name": "banjo",
                "unity_managed": false
            },
            {
                "server_name": "falco",
                "unity_managed": false
            }
        ]
    }
]