Expected \"(\" or keyword SELECT but got keyword WITH at

[LookerExperts]

Knowledge Drop

Last tested: Jan 17, 2019
 

This is one example of an error you can get by using a CTE in a derived table. See this article for more info: Can you use CTEs (WITH syntax) in a PDT? (common table expressions, aka WITH param).

This content is subject to limited support.