Query: Get all ancestors of a given organizational unit

Description

Ancestors are the units in the hierarchy that precede the given OU. An ancestor can be a direct parent (the immediate higher-level unit), or it can be any higher-level unit up to the root of the hierarchy.

Query

Tables used in this query:

• aws_organizations_organizational_unit

SQL