Instructions

1. Core Standards

1. Naming Convention: snake_case for the Explore name.
2. Required Parameters:
   • description: 100% Coverage. Every Explore MUST have a description.
   • label: A user-friendly name for the Explore in the UI.
   • view_name: Defaults to explore name, but explicit definition is safer.
3. Joins:
   • relationship: Required (one_to_one, many_to_one).
   • sql_on: Required. Use ${left.id} = ${right.id} syntax.
   • type: defaults to left_outer. Use inner or full_outer explicitly if needed.
4. Formatting:
   • Do NOT use from to rename views just for aesthetics. Use view_label instead.
   • Exception: Polymorphic joins, Self-joins, Rescoping extensions.

2. Advanced Configuration