CODEWITHSUNDEEP
snowflake-cloud-data-platform
Saurabh Verma
Saurabh Verma

Reputation: 6718

Interpretation of Steps (1/2) failed in Snowflake

I'm running an sql query on snowflake, which has been running for more than 24 hours. When I go to 'Profile Overview', I see Steps (1/2, Failed):

enter image description here

However, under 'Details' tab, I see that the status of the query is still 'Running'. Can someone please explain whether the query is still running or has there been some error ?

Upvotes: 2

Views: 1102

Answers (2)

Seeling Cheung
Seeling Cheung

Reputation: 157

Your query is likely resource (memory) intensive. Something to check in your query would include: - large sort or large number of sort? - large group by (or many aggregates?) - Many Windowing functions with order by?

For a query to be running for many hours, likely it would be best to dig deeper either with help of support (open case), or look for opportunity to review the query pattern.

Upvotes: 2

JB512
JB512

Reputation: 73

This must be retrying after failing on a first attempt. For example, it might have failed on a memory error and would retry internally twice (total three tries) before either successfully completing or failing with an error (in case all tries fail).

You may reach out to Snowflake Support for looking into this.

Upvotes: 2

Related Questions