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.

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

Request Body (POST)

xxxxxxxxxx

{

  "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

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.