Hi, I am writing some sql code in Looker ML but when I am referencing to another dimension that also has an existing SQL code, it is adding the entire SQL code of that referenced dimension. When I need to reference it multiple times this is creating a large code and duplicative. Is there a way I can reference an existing dimension that has SQL without pulling over the entire SQL code in SQL Runner?
Can you show us how you reference those fields?
Hi dphigravity,
I believe what you are looking for are Persistent Derived Tables (PDT).
Let me know if that helps!
Best regards,
Jasper