Cant use a variable in SQL query

Get Help
#1

For the following SQL query, in place of schema1 i cant use a variable for multi tenant architecture. (Single database with multiple schemas)

select * from schema1.some_trend WHERE user_id is not null AND (date(createtimestamp) between date('2022-11-04') AND date(current_date-1))

#2

No, not yet, we’re planning that feature for the short-medium term