topic Re: using variables in the physical schema joins in Data & Schema Discussions

using variables in the physical schema joins

prabhak — Mon, 07 Nov 2022 20:11:19 GMT

Has anyone tried using variables in the physical schema joins?

Re: using variables in the physical schema joins

ZachBreimayer — Tue, 08 Nov 2022 19:10:46 GMT

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

Re: using variables in the physical schema joins

prabhak — Wed, 09 Nov 2022 19:22:11 GMT

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).