SNOW-2395063: Document `AsyncJob.status()` return values in the docstring

[mkanetsuna]

Background

• The docstring of AsyncJob.status() in src/snowflake/snowpark/async_job.py relied on "etc." to describe possible return values, forcing readers to look up the full list elsewhere.
• The Snowflake documentation lists the QueryStatus values that the connector emits (https://docs.snowflake.com/ja/developer-guide/python-connector/python-connector-api#QueryStatus).

Problem

• API consumers cannot determine the full set of status values returned by AsyncJob.status() from the docstring alone, which slows down implementation and testing.

Proposal

Update the AsyncJob.status() docstring to enumerate the relevant snowflake.connector.cursor.QueryStatus.name values:

• "RUNNING", "SUCCESS", "FAILED_WITH_ERROR", "ABORTING", "ABORTED", "QUEUED",
  "DISCONNECTED", "RESUMING_WAREHOUSE", "QUEUED_REPAIRING_WAREHOUSE",
  "RESTARTED", "BLOCKED", "NO_DATA"

Expected Impact

• Readers can understand the possible return values from the docstring alone, reducing investigation time.

[sfc-gh-sghosh]

Hello @mkanetsuna ,

So, are you saying to update

snowpark-python/src/snowflake/snowpark/async_job.py

Line 5 in 888505c

from enum import Enum

def status(self) -> str:
"""
Returns a string representing the current status of the query.
(e.g., "RUNNING", "SUCCESS", "FAILED_WITH_ERROR", "ABORTING", etc.)
"""
status = self._session._conn._conn.get_query_status(self.query_id)
return status.name

With

def status(self) -> str:
"""
Returns a string representing the current status of the query.
(e.g., "RUNNING", "SUCCESS", "FAILED_WITH_ERROR", "ABORTING", "ABORTED", "QUEUED", "DISCONNECTED", "RESUMING_WAREHOUSE", "QUEUED_REPAIRING_WAREHOUSE", "RESTARTED", "BLOCKED", "NO_DATA" etc.)
"""
status = self._session._conn._conn.get_query_status(self.query_id)
return status.name

That depends on the implementation, if we can not determine the status like queued, resuming_warehouse etc, then there is no value addition. Will check with team and update.