Skip to main content

View

Like most RDBMS, a view is the result set of a stored query, and we can use all accio data objects model, metric, view and all accio functions in view.


view {
  numberOfOrders: `select count(*) from Orders`,
  ordersPerCustomer: `select name, transform(orders, o -> o.orderkey) orderkeys from Customer`
  ordersView: `select * from Orders`,
  orderKeys: `select distinct(orderkey) from ordersView`
}
  • Note that the views ordering matters, if we want to use view in another view, e.g. view orderKeys use view ordersView in its sql, then orderKeys should be placed under ordersView.
  • (WIP) Currently accio view not support WITH statement

And we could treat view as regular table in sql.

SELECT * FROM numberOfOrders;

 count
-------
 15000