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

jobId

This is an example of an error that could be returned for resource not found

Error

application/vnd.sas.error

Get the state of the specified job

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

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

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.

Status	Meaning	Description
200	OK	the state.		Schema
404	Not Found	Not found.		Schema

Get the state of the specified job

Request Samples

Response Samples

Path Parameters

Responses