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 __init__(
      self,
      *,
      target_table_name: str,
      postgres_conn_id: str = "postgres_default",
      **kwargs,
  ) -> None:
      super().__init__(target_table_name=target_table_name, **kwargs)
      self.postgres_conn_id = 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 1 to create a new BigQueryToPostgresOperator object from inherited base classes: BigQueryToSqlBaseOperator with example: obj = BigQueryToPostgresOperator()