GET (Tables) - Teradata Ecosystem Manager

Teradata Ecosystem Manager API Reference

Product
Teradata Ecosystem Manager
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
crq1488477755125.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-3204
lifecycle
previous
Product Category
Analytical Ecosystem

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