OracleOperator

Oracle

Executes sql code in a specific Oracle database

View Source

Last Updated: May. 6, 2021

Access Instructions

Install the Oracle provider package into your Airflow environment.

Import the module into your DAG file and instantiate it with your desired params.

Parameters

sqlstr or list[str]the sql code to be executed. Can receive a str representing a sql statement, a list of str (sql statements), or reference to a template file. Template reference are recognized by str ending in '.sql' (templated)
oracle_conn_idstrreference to a specific Oracle database
parametersdict or iterable(optional) the parameters to render the SQL query with.
autocommitboolif True, each command is automatically committed. (default value: False)

Documentation

Executes sql code in a specific Oracle database

Example DAGs

Improve this module by creating an example DAG.

View Source
  1. Add an `example_dags` directory to the top-level source of the provider package with an empty `__init__.py` file.
  2. Add your DAG to this directory. Be sure to include a well-written and descriptive docstring
  3. Create a pull request against the source code. Once the package gets released, your DAG will show up on the Registry.

Was this page helpful?