HomeGuidesRecipesAPI ReferencePython SDK
Alation Help Center
API Reference

Relational Integration API Overview

Relational Integration APIs

Description

This API allows users to create and read technical and logical metadata together for virtual and non-virtual RDBMS data sources. Users with appropriate permissions can create schemas, tables and columns under a particular data source along with their custom fields.

This API's POST methods act as a POST and not a PATCH. All fields not included in a POST request will be set to a default value.

Permissions

API MethodPrivate Data SourcePublic Data Source
GETAllowed for all user roles.Allowed only for Server Admin, Catalog Admin, and Source Admin roles with access level as a Data Source Admin.
POSTAllowed for all user roles with access level as Data Source Viewer or Data Source Admin on the private data source.Allowed only for Server Admin, Catalog Admin, and Source Admin roles with access level as a Data Source Admin.

POST Payload Size Limits

In order to prevent API calls from overwhelming Alation, this API has limits on how many objects can be submitted in the payload of a POST method. This is a hard limitation that is not configurable. The limit depends on the object type, as shown in the table below.

Object TypeMax Objects in POST Payload
Schema1,000
Table1,000
Column10,000

If you need to POST more objects than the limit allows, we recommend splitting the payload into smaller sizes and submitting multiple API calls.

OpenAPI 3.0 Specification

The Relational Integration APIs uses the OpenAPI 3.0 Specification (OAS). OAS is a broadly adopted industry standard for describing APIs.

To see the specification, replace {AlationInstanceURL} below with your Alation instance's URL and visit the link:

{AlationInstanceURL}/openapi/integration_apis/

NOTE:

  1. This API is available in Alation 2021.2 and later.
  2. The OpenAPI UI is not enabled by default on an Alation instance. Please set the flag alation.feature_flags.enable_swagger to True using alation_conf.