Getting the query ID of the last query (original) (raw)

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 use Snowflake CLI, SnowSQL, the Classic Console, or theexecute_stream or execute_string method in Python Connectorcode, use this example instead (see Using Snowflake Scripting in Snowflake CLI, SnowSQL, the Classic Console, and Python Connector):

EXECUTE IMMEDIATE DECLAREqueryid1VARCHAR;queryid2VARCHAR;BEGINSELECT1;queryid1:=SQLID;SELECT2;queryid2:=SQLID;RETURN[queryid1,queryid2];END;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;DECLAREqueryi​d1​VARCHAR;queryi​d2​VARCHAR;BEGINSELECT1;queryi​d1​:=SQLID;SELECT2;queryi​d2​:=SQLID;RETURN[queryi​d1​,queryi​d2​];END; ;