airflow.providers.microsoft.mssql.operators.mssql
¶
Module Contents¶
Classes¶
Executes sql code in a specific Microsoft SQL database |
- class airflow.providers.microsoft.mssql.operators.mssql.MsSqlOperator(*, sql, mssql_conn_id='mssql_default', parameters=None, autocommit=False, database=None, **kwargs)[source]¶
Bases:
airflow.models.BaseOperator
Executes sql code in a specific Microsoft SQL database
See also
For more information on how to use this operator, take a look at the guide: MsSqlOperator
This operator may use one of two hooks, depending on the
conn_type
of the connection.If conn_type is
'odbc'
, thenOdbcHook
is used. Otherwise,MsSqlHook
is used.- Parameters
sql (str) -- the sql code to be executed (templated)
mssql_conn_id (str) -- reference to a specific mssql database
parameters (Optional[Union[Mapping, Iterable]]) -- (optional) the parameters to render the SQL query with.
autocommit (bool) -- if True, each command is automatically committed. (default value: False)
database (Optional[str]) -- name of database which overwrite defined one in connection