code: def test_return_sql_result(self, mock_conn):
      expected_result = {"Result": True}
      mock_conn.execute_statement.return_value = {"Id": STATEMENT_ID}
      mock_conn.describe_statement.return_value = {"Status": "FINISHED"}
      mock_conn.get_statement_result.return_value = expected_result
      cluster_identifier = "cluster_identifier"
      db_user = "db_user"
      secret_arn = "secret_arn"
      statement_name = "statement_name"
      operator = RedshiftDataOperator(
          task_id=TASK_ID,
          cluster_identifier=cluster_identifier,
          database=DATABASE,
          db_user=db_user,
          sql=SQL,
          statement_name=statement_name,
          secret_arn=secret_arn,
          aws_conn_id=CONN_ID,
          return_sql_result=True,
      )
      actual_result = operator.execute(None)
      assert actual_result == expected_result
      mock_conn.execute_statement.assert_called_once_with(
          Database=DATABASE,
          Sql=SQL,
          ClusterIdentifier=cluster_identifier,
          DbUser=db_user,
          SecretArn=secret_arn,
          StatementName=statement_name,
          WithEvent=False,
      )
      mock_conn.get_statement_result.assert_called_once_with(
          Id=STATEMENT_ID,
      )
  
file_path: airflow/tests/providers/amazon/aws/operators/test_redshift_data.py
imports: from __future__ import annotations
  from unittest import mock
  import pytest
  from airflow.exceptions import AirflowProviderDeprecationWarning
  from airflow.providers.amazon.aws.operators.redshift_data import RedshiftDataOperator
label_desc: Use image node_id 6 for calling the TestRedshiftDataOperator obj's underlying member method code with example usage: obj.test_return_sql_result(mock_conn) without return types