Acceldata
Acceldata
Search docs… ⌘K
Last updated:

SQL Views

SQL Views (Custom Assets) let you create virtual assets on top of existing datasets. Use this API when you need derived datasets for analysis.

For example, create a “regional_sales” view that aggregates transactions across multiple source tables.

Info

⚠️ All endpoints require authentication. See Authentication & Headers.

Endpoint(s)

  • POST /catalog-server/api/custom-assets/sql-view
  • GET /catalog-server/api/custom-assets/sql-view/:id
  • PUT /catalog-server/api/custom-assets/sql-view/:id
  • DELETE /catalog-server/api/custom-assets/sql-view/:id

Path Parameters

Name

Type

Required

Description

Example

id

int

Yes

SQL View ID

501

Request Body (POST)

Json

{

"data": {

"asset": {

"name": "regional_sales",

"assemblyId": 5,

"assetTypeId": 2,

"isCustom": true

},

"details": {

"query": "SELECT region, SUM(sales) as total FROM orders GROUP BY region"

}

}

}

Sample Request

Bash

curl -X POST "https://demo.acceldata.io/catalog-server/api/custom-assets/sql-view"

-d '{"data":{"asset":{"name":"regional_sales","assemblyId":5,"assetTypeId":2,"isCustom":true},"details":{"query":"SELECT region, SUM(sales) as total FROM orders GROUP BY region"}}}'

Response Schema

See SQL View Schema.