SQL View Schema

Returned by SQL Views.

Top-level Fields

Field

Type

Description

id

integer

SQL view ID

name

string

View name

query

string

SQL definition

assemblyId

integer

Source assembly

assetTypeId

integer

Asset type

Example JSON

{ "id": 501, "name": "regional_sales", "query": "SELECT * FROM orders" }