class_docstr: Fetch data from a BigQuery table (alternatively fetch selected columns) and insert into PostgreSQL table.
  
  .. seealso::
      For more information on how to use this operator, take a look at the guide:
      :ref:`howto/operator:BigQueryToPostgresOperator`
  
  :param target_table_name: target Postgres table (templated)
  :param postgres_conn_id: Reference to :ref:`postgres connection id <howto/connection:postgres>`.
class_docstr_tok: ["Fetch","data","from","a","BigQuery","table","(","alternatively","fetch","selected","columns",")","and","insert","into","PostgreSQL","table",".","..","seealso",":",":","For","more","information","on","how","to","use","this","operator",",","take","a","look","at","the","guide",":",":","ref",":","`","howto\/operator",":","BigQueryToPostgresOperator","`",":","param","target_table_name",":","target","Postgres","table","(","templated",")",":","param","postgres_conn_id",":","Reference","to",":","ref",":","`","postgres","connection","id","<","howto\/connection",":","postgres",">","`","."]
code: def get_sql_hook(self) -> PostgresHook:
      return PostgresHook(
          schema=self.database, postgres_conn_id=self.postgres_conn_id
      )
  
imports: from __future__ import annotations
  from airflow.providers.google.cloud.transfers.bigquery_to_sql import BigQueryToSqlBaseOperator
  from airflow.providers.postgres.hooks.postgres import PostgresHook
label_desc: Use image node_id 2 for calling the BigQueryToPostgresOperator obj's underlying member method code with example usage: obj.get_sql_hook() and returns: PostgresHook