SQL Tile - not able to reference CTE name in itself when using recursion
I am trying to do a fairly simple recursion cte to navigate an employee hierarchy and assign an integer "level" to each employee based on their place in the org. I am using a SQL tile in a Magic ETL. I am getting an error from Domo "Table Not Found: hierarchytable". This I believe is referencing the FROM hierarchytable as…
