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.
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
ordersViewin its sql, then orderKeys should be placed under ordersView.
- (WIP) Currently accio view not support
And we could treat view as regular table in sql.
SELECT * FROM numberOfOrders;