big query table functions parameters

Question

Is this supported in bigquery

select a
from table_with_parameters AS t
JOIN my_table_fuction(t.par1, t.par2, t.par3) AS u

I keep getting undetified identifier "t" on line 3...

Answer 1

Not in the way you have it, you need to add in the columns you need into the SELECT statement, an example would be

SELECT 
a,
t.par1,
t.par2,
t.par3

FROM table_with_parameters 
INNER JOIN my_table_fuction AS t

Its hard to say with the example you've provided though.