code: def test_hook_params(self, mock_get_conn):
      mock_get_conn.return_value = Connection(
          conn_id="postgres_test", conn_type="postgres"
      )
      op = SqlToS3Operator(
          query="query",
          s3_bucket="bucket",
          s3_key="key",
          sql_conn_id="postgres_test",
          task_id="task_id",
          sql_hook_params={
              "log_sql": False,
          },
          dag=None,
      )
      hook = op._get_hook()
      assert hook.log_sql == op.sql_hook_params["log_sql"]
  
file_path: airflow/tests/providers/amazon/aws/transfers/test_sql_to_s3.py
imports: from __future__ import annotations
  from tempfile import NamedTemporaryFile
  from unittest import mock
  import pandas
  import pytest
  from airflow.exceptions import AirflowException
  from airflow.models import Connection
  from airflow.providers.amazon.aws.transfers.sql_to_s3 import SqlToS3Operator
label_desc: Use image node_id 8 for calling the TestSqlToS3Operator obj's underlying member method code with example usage: obj.test_hook_params(mock_get_conn) without return types