I’ve used NDT to create a user-level aggregation of another entity. Joined it by user_id and it works perfectly fine apart from the fact that the joined dimension doesn’t show up in data table or drill fields
The first one comes from the NDT. If I copy the SQL generated by Looker into my warehouse, the query returns it without a problem, which makes sense because SQL is valid and the join works, so it must be something to do with the data table engine.
Renaming the NDT dimension to something other than user_id didn’t have any impact