airflow.providers.google.cloud.transfers.bigquery_to_mssql

This module contains Google BigQuery to MSSQL operator.

Module Contents

Classes

BigQueryToMsSqlOperator

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

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

Fetch data from a BigQuery table (alternatively fetch selected columns) and insert it 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 origin

  • mssql_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

template_fields: Sequence[str] = ()[source]
get_sql_hook()[source]

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

This function persists the connection to the SQL provider.

Was this entry helpful?