docstr: Asserts that a task is deferred and an SnowflakeSqlApiTrigger will be fired
  when the SnowflakeSqlApiOperator is executed.
docstr_tok: ["Asserts","that","a","task","is","deferred","and","an","SnowflakeSqlApiTrigger","will","be","fired","when","the","SnowflakeSqlApiOperator","is","executed","."]
code: def test_snowflake_sql_api_execute_operator_async(
      self, mock_db_hook, mock_sql, statement_count
  ):
      """
      Asserts that a task is deferred and an SnowflakeSqlApiTrigger will be fired
      when the SnowflakeSqlApiOperator is executed.
      """
      operator = SnowflakeSqlApiOperator(
          task_id=TASK_ID,
          snowflake_conn_id=CONN_ID,
          sql=mock_sql,
          statement_count=statement_count,
          deferrable=True,
      )
  
      with pytest.raises(TaskDeferred) as exc:
          operator.execute(create_context(operator))
  
      assert isinstance(
          exc.value.trigger, SnowflakeSqlApiTrigger
      ), "Trigger is not a SnowflakeSqlApiTrigger"
  
imports: from __future__ import annotations
  from unittest import mock
  import pendulum
  import pytest
  from airflow.exceptions import AirflowException, TaskDeferred
  from airflow.models.dag import DAG
  from airflow.models.dagrun import DagRun
  from airflow.models.taskinstance import TaskInstance
  from airflow.providers.snowflake.operators.snowflake import SnowflakeCheckOperator, SnowflakeIntervalCheckOperator, SnowflakeOperator, SnowflakeSqlApiOperator, SnowflakeValueCheckOperator
  from airflow.providers.snowflake.triggers.snowflake_trigger import SnowflakeSqlApiTrigger
  from airflow.utils import timezone
  from airflow.utils.types import DagRunType
label_desc: Use image node_id 6 for calling the TestSnowflakeSqlApiOperator obj's underlying member method code with example usage: obj.test_snowflake_sql_api_execute_operator_async(mock_db_hook, mock_sql, statement_count) without return types