Parameterized view / table functions


#1

Hi,

does Dremio support parameterized views (or Table Functions as they are called in Oracle)? In our use case we have a query (view / table function) that uses “effective date”. “effective date” is used in a SQL window function to determine the latest valid version of a record at an"effective date".
E.g. select * from table(my_view(2018.09.20))

thanks a lot
Juergen


#2

Even I have same question, can anyone answer this question?