Build in ekai
Discovery›Sales warehouseSchema & Relationships
SALES.ORDERSORDER_ID7 columns
CRM.CUSTOMERSCUSTOMER_ID5 columns
SALES.ORDER_ITEMSORDER_ITEM_ID7 columns
REF.REGIONSREGION_CODE4 columns
REF.FISCAL_CALENDARFISCAL_DATE4 columns
REGION_CODECUSTOMER_IDREGION_CODEORDER_DATEORDER_ID- CUSTOMERS→REGIONS
REGION_CODE - ORDERS→CUSTOMERS
CUSTOMER_ID - ORDERS→REGIONS
REGION_CODE - ORDERS→FISCAL_CALENDAR
ORDER_DATE - ORDER_ITEMS→ORDERS
ORDER_ID
Schema AgentKeys · Relationships · Documentation · Entity relationship (DBML)
Discovery › Onboarding
Onboarding Agent
Which schema is the source of truth for orders?
1SALES, loaded nightly from the order system2LEGACY, kept for history onlyAnswered 1 question
ekai raises $1.7MBacked by Misneach and C10 Labs. Yahoo Finance ↗