Cant use a variable in SQL query

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

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