airflow.providers.google.cloud.transfers.bigquery_to_mssql
¶
This module contains Google BigQuery to MSSQL operator.
Module Contents¶
Classes¶
Fetches the data from a BigQuery table (alternatively fetch data for selected columns) |
- class airflow.providers.google.cloud.transfers.bigquery_to_mssql.BigQueryToMsSqlOperator(*, source_project_dataset_table, mssql_table=None, target_table_name=None, mssql_conn_id='mssql_default', **kwargs)[source]¶
Bases:
airflow.providers.google.cloud.transfers.bigquery_to_sql.BigQueryToSqlBaseOperator
Fetches the data from a BigQuery table (alternatively fetch data for selected columns) and insert that data into a MSSQL table.
See also
For more information on how to use this operator, take a look at the guide: Operator
- Parameters
source_project_dataset_table (str) – A dotted
<project>.<dataset>.<table>
: the big query table of originmssql_table (str | None) – target MsSQL table. It is deprecated: use target_table_name instead. (templated)
target_table_name (str | None) – target MsSQL table. It takes precedence over mssql_table. (templated)
mssql_conn_id (str) – reference to a specific mssql hook