Skip to main content

Explore

Explore is an entry point to building any report and describes how views (native SQL tables or derived tables) are related.

Explore Syntax

name.explore.aml
#Defining the new explore
explore: explore_name {
label: View Name
from: view_name
hidden: yes | no

join: join_name {...}
}

explore: +explore_name {...}

Explore Syntax Example

sales.explore.aml
explore: sales {
from: orders

join: order_items {
sql_on: ${order_items.order_id} = ${orders.id} ;;
}

join: products {
sql_on: ${products.id} = ${order_items.product_id} ;;
}
}