OracleToOracleOperator

Oracle

Moves data from Oracle to Oracle.

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

oracle_destination_conn_idstrdestination Oracle connection.
destination_tablestrdestination table to insert rows.
oracle_source_conn_idstrsource Oracle connection.
source_sqlstrSQL query to execute against the source Oracle database. (templated)
source_sql_paramsdictParameters to use in sql query. (templated)
rows_chunkintnumber of rows per chunk to commit.

Documentation

Moves data from Oracle to Oracle.

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?