Getting the Query ID of the Last Query¶
If you need to access the query ID of the last query that was executed, use the global variable SQLID
.
Note
If no query was executed, the default value of SQLID
is NULL.
The following example executes two queries and returns an ARRAY containing the query IDs:
DECLARE query_id_1 VARCHAR; query_id_2 VARCHAR; BEGIN SELECT 1; query_id_1 := SQLID; SELECT 2; query_id_2 := SQLID; RETURN [query_id_1, query_id_2]; END;Note: If you are using SnowSQL or the Classic Console, use this example instead (see Using Snowflake Scripting in SnowSQL and the Classic Console):
EXECUTE IMMEDIATE $$ DECLARE query_id_1 VARCHAR; query_id_2 VARCHAR; BEGIN SELECT 1; query_id_1 := SQLID; SELECT 2; query_id_2 := SQLID; RETURN [query_id_1, query_id_2]; END; $$ ;