Asset Resolution in Subqueries

When using subqueries in join() and defineTable(), assets (saved queries and files) follow different resolution rules:

  • join() Subqueries

    • Saved queries are resolved from the view where the main query runs.

    • Files are resolved from the view where the subquery runs.

  • defineTable() Subqueries

    • Both saved queries and files are resolved from the view where the subquery runs.