We work with a Snoflake DB. When running queries in workbench (/others) we use this syntax a lot:
set LAST_DAYS = (select DATE_PART('EPOCH_MILLISECOND', TO_TIMESTAMP(current_timestamp)) / 1000 - 60 * 60 * 24 * 10); select * from table where table.TIMESTAMP> $last_days
is this doable in REDASH?
I run the top row separately - statement executes successfully.
Then I try to run the rest of the query, but redash says " SQL compilation error: error line 3 at position 26 Session variable ‘$LAST_DAYS’ does not exist"
(the same sequance does work with this DB in other tools - workbench/data-grip etc)