SQL Code being re-used

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?

0 2 83
2 REPLIES 2

Dawid
Participant V

Can you show us how you reference those fields?

blue1
Participant III

Hi dphigravity,

I believe what you are looking for are Persistent Derived Tables (PDT).

Let me know if that helps!

Best regards,
Jasper

Top Labels in this Space
Top Solution Authors