Create Datamart - Databrain

{
  "name": "string",              // Required
  "datasourceName": "string",    // Required
  "tableList": [                 // Required, non-empty
    {
      "schemaName": "string",    // Optional if non schema datasource
      "name": "string",          // Required
      "columns": [               // Required, non-empty
        {
          "name": "string",      // Required
          "alias": "string"      // Optional
        }
      ]
    }
  ]
}

{
  "id": "string",    // Datamart name
  "error": null
}

POST

api

dataApp

datamart

create

{
  "name": "string",              // Required
  "datasourceName": "string",    // Required
  "tableList": [                 // Required, non-empty
    {
      "schemaName": "string",    // Optional if non schema datasource
      "name": "string",          // Required
      "columns": [               // Required, non-empty
        {
          "name": "string",      // Required
          "alias": "string"      // Optional
        }
      ]
    }
  ]
}

{
  "id": "string",    // Datamart name
  "error": null
}

Endpoint

POST /create

Headers

Authorization

string

required

Bearer API TOKEN

Request Body

name

string

required

Name of the datamart to create.

datasourceName

string

required

The datasource to which this datamart belongs.

tableList

array

required

Array of tables with columns to include in the datamart.

tableList[].schemaName

string

Optional schema name (required only for schema-based datasources).

tableList[].name

string

required

Table name.

tableList[].columns

array

required

List of column objects for this table.

tableList[].columns[].name

string

required

Column name.

tableList[].columns[].alias

string

Optional alias for the column.

{
  "name": "string",              // Required
  "datasourceName": "string",    // Required
  "tableList": [                 // Required, non-empty
    {
      "schemaName": "string",    // Optional if non schema datasource
      "name": "string",          // Required
      "columns": [               // Required, non-empty
        {
          "name": "string",      // Required
          "alias": "string"      // Optional
        }
      ]
    }
  ]
}

{
  "id": "string",    // Datamart name
  "error": null
}

Error Response

HTTP Code	Code	Message
400	`INVALID_REQUEST_BODY`	Invalid request body
400	`DATASOURCE_NAME_ERROR`	Invalid datasource name
400	`INVALID_REQUEST_BODY`	Table list cannot be empty
400	`INVALID_REQUEST_BODY`	Invalid table or column structure
400	`INVALID_REQUEST_BODY`	Invalid schema or table name
400	`INVALID_REQUEST_BODY`	Invalid column names in table
400	`INVALID_TENANCY`	Invalid tenancy level for organization
500	`INTERNAL_SERVER_ERROR`	Server error

Datamart API Delete Datamart

​Endpoint

​Headers

​Request Body

​Error Response

Endpoint

Headers

Request Body

Error Response