| :mod:`airflow.operators.mssql_operator` |
| ======================================= |
| |
| .. py:module:: airflow.operators.mssql_operator |
| |
| |
| Module Contents |
| --------------- |
| |
| .. py:class:: MsSqlOperator(sql, mssql_conn_id='mssql_default', parameters=None, autocommit=False, database=None, *args, **kwargs) |
| |
| Bases: :class:`airflow.models.BaseOperator` |
| |
| Executes sql code in a specific Microsoft SQL database |
| |
| :param sql: the sql code to be executed |
| :type sql: str or string pointing to a template file with .sql |
| extension. (templated) |
| :param mssql_conn_id: reference to a specific mssql database |
| :type mssql_conn_id: str |
| :param parameters: (optional) the parameters to render the SQL query with. |
| :type parameters: mapping or iterable |
| :param autocommit: if True, each command is automatically committed. |
| (default value: False) |
| :type autocommit: bool |
| :param database: name of database which overwrite defined one in connection |
| :type database: str |
| |
| .. attribute:: template_fields |
| :annotation: = ['sql'] |
| |
| |
| |
| .. attribute:: template_ext |
| :annotation: = ['.sql'] |
| |
| |
| |
| .. attribute:: ui_color |
| :annotation: = #ededed |
| |
| |
| |
| |
| .. method:: execute(self, context) |
| |
| |
| |
| |
