Oracle Database Support

[senorkrabs]

Is your feature request related to a problem? Please describe.
awswrangler supports a variety of database engines - MySQL, Postgres, and MS SQL - but does not yet have support for Oracle. When building a data lake in an Enterprise, it is often the case that data needs to be extracted from Oracle databases and warehouses. In some cases, data may need to be written back to a table in an Oracle database as well.

Describe the solution you'd like
Add support for Oracle databases with functionality similar to the other supported database engines: connect, read_sql_table, read_sql_query, and to_sql

P.S. Don't attach files. Please, prefer add code snippets directly in the message body.

[adamblvck]

I'm indeed looking for this feature too, however... I wonder how this will work out, knowing that Oracle Drivers addS about 70MB compressed, needs licensing, and the setup with drivers is an incredible hassle.

[jaidisido]

We are investigating the requirements for this in terms of:

• Licensing
• Size of the package
• Required drivers

and will revert back once we understand more

[rhanson32]

this is great news that this is WIP as this is something that would really come in handy for me... is there any update on where this feature is after April 30?

[AdrianoNicolucci]

Is there any update on Oracle Database Support? We have a use case to leverage oracle with aws data wrangler and would love to see this implemented.

[djsaroka]

Are there any updates to this? I also would love to see this implemented and have many use cases for it.

[github-actions]

This issue requires triage and should be assigned.