sfquickstarts
sfquickstarts copied to clipboard
restoring station name in step 8 does not work
I'm in step 8 of your tutorial (https://quickstarts.snowflake.com/guide/getting_started_with_snowflake/?utm_cta=website-workload-data-warehouse-resources-data-analysts-guide#7), in the section entitled "Roll back a table".
I execute the command
set query_id =
(select query_id from table(information_schema.query_history_by_session (result_limit=>5))
where query_text like 'update%' order by start_time limit 1);
and get back
Statement executed successfully
But when I enter the next command,
create or replace table trips as
(select * from trips before (statement => $query_id));
I get
Statement $QUERY_ID not found.
instead of the intended table restoration.
Desktop (please complete the following information):
- OS: iOS
- Browser Firefox
- Version 96.0.3]