MsSqlOperator
MSSQLExecutes sql code in a specific Microsoft SQL database
Access Instructions
Install the MSSQL provider package into your Airflow environment.
Import the module into your DAG file and instantiate it with your desired params.
Parameters
sqlthe sql code to be executed (templated)
mssql_conn_idreference to a specific mssql database
parameters(optional) the parameters to render the SQL query with.
autocommitif True, each command is automatically committed. (default value: False)
databasename of database which overwrite defined one in connection
Documentation
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', then OdbcHook is used. Otherwise, MsSqlHook is used.