Manage all aspects of data quality, data sources, and tables

data_management

2022.09

2024.07

Viya_35

2023.03

2024.08

2024.10

2023.10

2024.03

2024.09

The Data Tables API works in concert with the Data Sources and Row Sets APIs to navigate, reference, and retrieve data in the SAS Viya ecosystem. The Data Tables API enables retrieval of metadata for data tables and their respective columns. All GET operations have a corresponding HEAD with identical signature and semantics except the resource body is not returned. Terminology: table: represents a rectangular data structure that consists of rows
 and columns of uniform data. 
data table: represents a rectangular data structure that consists of rows and columns
 of uniform data. 
data source: represents a node in the data source hierarchy that can
 represent a server, library, or collection of tables. 
column: represents a column of rectangular data. row: represents a row of rectangular data. cell: represents the value where a row and column intersect. provider: represents a service that has registered itself as a provider of data
 table information. These services provide table and column metadata
for
 specific environments such as SAS Compute Server or CAS. 
session: represents a semi-permanent interactive information
 interchange between the client that uses this API and the provider service
 returning the metadata. 
long poll: implements requests to either create (POST) a table, or get an existing job that can
 optionally wait at the server for the completion of the job.
 The maximum time out is 30 seconds. The job might return incomplete,
 in which case the user can reissue another long poll request.

Data Tables

Returns a collection of links to the top-level collections surfaced through this API. HEAD is also supported.

A list of links to top level resources available from the root of the API.

Get a list of top-level links

Table

Table Collection

Column

Column Summary

Column Summary Collection

The resource that represents the format of a column.

Format

The resources that represent the informat of the column.

Informat

Column Argument

The target arguments for the create request

Table Request Target arguments

This represents the input to create a table.

Table create

Table create request details for CAS with SASHdat sources

The source arguments for the create request

Table Request Source Arguments

This represents the job to create a table.

Table Create Job

Table Create request

Error

This is a base schema used to define paginated collections of resources. This base schema is extended by other schemas in APIs by adding an 'items' array property. These extensions define the application/vnd.sas.collection media type (version 2)

Base Collection

A link to a related operation or resource.

Get a list of top-level links

Request Samples

Response Samples

Responses