Query Profile for queries executed by a TASK
From TASK_HISTORY & QUERY_HISTORY,I can see details of the queries executed by a scheduled TASK. But When I look them up in Snowsight, query couldn't be found. I am curious to see Profile of the query executed by the TASK.
Otherwise is there any alternate way to compare/troubleshoot query execution/plan via sql in Snowflake?
Can you please make sure you have enabled "Queries executed by user tasks" option in snowsight to view the SQL statements executed or stored procedures called by user tasks.
Please review the below documentation for more information:
https://docs.snowflake.com/en/user-guide/ui-history#overview-of-features
https://docs.snowflake.com/en/user-guide/ui-snowsight-activity#filter-query-history
You can also use the GET_QUERY_OPERATOR_STATS that returns statistics about individual query operators within a query that has completed.
Please review the below documentation for more information:
https://docs.snowflake.com/en/sql-reference/functions/get_query_operator_stats
- How to replace NULL to specific string in snowflake (SQL)
- Preserving the load history when re-creating pipes in Snowflake
- Azure Data Factory Data Flows - Forcing headers into upper case for mapping
- Array_Agg does not support Window Frame in Snowflake - how to achieve?
- How to convert a VARCHAR to DATE in Snowflake
- Alternative to st.file_uploader Snowflake Streamlit
- How to handle the exception in Snowflake SQL scripting stored procedure with return type as TABLE
- How to show which authentication policy is applied to a user in Snowflake
- Update null values in a column with values from same table but by referencing indirectly related matching value in another table
- How to deploy SQL views to snowflake using config object?
- Snowflake Snowpark Python - Stored Procedure
- Using multiple AND/OR statements breaks my date filter
- Flatten XML array to a single row in Snowflake
- Snowflake: getting value from inner tags of xml file
- How can I group by a case column that uses a JSON object?
- Conditional CASE WHEN select snowflake SQL
- Snowflake SQL group-by behaving differently depending whether columns are referenced by position or alias
- Search comparing and searching for strings in a variant table, trouble with correct construct for varient type
- How to find tables using row access policies in Snowflake
- Converting a column containing UTC values to EST values in Snowflake
- multiple CASE when statement
- How to alter primary key in table for snowflake?
- Attempting to save a resultset to a table. Snowflake SQL scripting
- Remove a column comment in Snowflake
- Snowflake join on mixed datatypes not returning results
- Granular access control for shared databases in Snowflake
- How do I resolve SnowparkSQLException: ... User is empty in function for Snowpark python SPROC invocation?
- _udf_code error when using filter within a Python Stored Procedure
- SQL-Snowflake - How to count the days between dates in 2 or more rows with WHERE condition
- Copying files from AWS S3 to Snowflake Table using Snowflake Stored Procedure