cancel
Showing results for 
Search instead for 
Did you mean: 

using variables in the physical schema joins

prabhak
Ranger

Has anyone tried using variables in the physical schema joins? 

prabhak_0-1667851676537.png

 

 

2 REPLIES 2

ZachBreimayer
Employee
Employee

Hi Prabhak,

Please clarify with further detail on what you are trying to accomplish if I miss the mark here. It appears to me that you are simply trying to reduce the resultset. This may be ideal to simply add into the SQL scripts. Again, If that is the case and you face any challenges please clarify with further detail.

Regards,

Zach, Solutions Engineer

prabhak
Ranger

Yes, i was trying to reduce the result set, trying to expose only the records that are active as of today (using CURRENT_DATE session variable). 

Dylan from Incorta has helped me understand this one - " The joins are calculated during loading time and cannot be dynamic (so can't use variables in the joins).