docs-archive/apache-airflow-providers-google/10.17.0/_sources/_api/airflow/providers/google/cloud/transfers/bigquery_to_mssql/index.rst.txt

:py:mod:`airflow.providers.google.cloud.transfers.bigquery_to_mssql`
====================================================================

.. py:module:: airflow.providers.google.cloud.transfers.bigquery_to_mssql

.. autoapi-nested-parse::

   This module contains Google BigQuery to MSSQL operator.



Module Contents
---------------

Classes
~~~~~~~

.. autoapisummary::

   airflow.providers.google.cloud.transfers.bigquery_to_mssql.BigQueryToMsSqlOperator




.. py:class:: BigQueryToMsSqlOperator(*, source_project_dataset_table, mssql_table = None, target_table_name = None, mssql_conn_id = 'mssql_default', **kwargs)


   Bases: :py:obj:`airflow.providers.google.cloud.transfers.bigquery_to_sql.BigQueryToSqlBaseOperator`

   Fetch data from a BigQuery table (alternatively fetch selected columns) and insert it into a MSSQL table.

   .. seealso::
       For more information on how to use this operator, take a look at the guide:
       :ref:`howto/operator:BigQueryToMsSqlOperator`

   :param source_project_dataset_table: A dotted ``<project>.<dataset>.<table>``:
       the big query table of origin
   :param mssql_table: target MsSQL table. It is deprecated: use target_table_name instead. (templated)
   :param target_table_name: target MsSQL table. It takes precedence over mssql_table. (templated)
   :param mssql_conn_id: reference to a specific mssql hook

   .. py:attribute:: template_fields
      :type: Sequence[str]
      :value: ()

      

   .. py:attribute:: operator_extra_links
      :value: ()

      

   .. py:method:: get_sql_hook()

      Return a concrete SQL Hook (a PostgresHook for instance).


   .. py:method:: persist_links(context)

      Persist the connection to the SQL provider.