At the moment, it looks like it’s not possible to use CTE’s within an AML Model
In most cases, this does make sense, as you would create them as separate models. But we do have some users requesting being able to do this - usually because they’re taking an existing single-purpose query and want to see it in Holistics. They’re typically single purpose enough that it doesn’t warrant breaking it up into separate models.
Has anyone found any workaround to this?