airflow.providers.jdbc.operators.jdbc
¶
Module Contents¶
Classes¶
Executes sql code in a database using jdbc driver. |
- class airflow.providers.jdbc.operators.jdbc.JdbcOperator(*, sql, jdbc_conn_id='jdbc_default', autocommit=False, parameters=None, **kwargs)[source]¶
Bases:
airflow.models.BaseOperator
Executes sql code in a database using jdbc driver.
Requires jaydebeapi.
See also
For more information on how to use this operator, take a look at the guide: JdbcOperator
- Parameters
sql (Union[str, List[str]]) -- the SQL code to be executed as a single string, or a list of str (sql statements), or a reference to a template file. Template references are recognized by str ending in '.sql'
jdbc_conn_id (str) -- reference to a predefined database
autocommit (bool) -- if True, each command is automatically committed. (default value: False)
parameters (Optional[Union[Mapping, Iterable]]) -- (optional) the parameters to render the SQL query with.