replace cx_oracle with python-oracledb

[jrlittlefoot64]

Hello I need the steps to replace cx_oracle with python-oracledb in superset docker-compose (version 4,0,2 and 4.1) to run superset without extra container for oracle client
thank you!

[dosubot[bot]]

I found a similar open issue regarding replacing cx_Oracle with python-oracledb in Superset ^[1]. Here's a suggested solution:

1. Modify superset_config.py: Add the following code snippet to replace cx_Oracle with python-oracledb:

   import sys
   import oracledb
   oracledb.version = "8.3.0"
   sys.modules["cx_Oracle"] = oracledb
   import cx_Oracle

2. Install the new driver: Make sure to install python-oracledb by running:

   python -m pip install oracledb

3. Update SQLAlchemy URI: Use the SQLAlchemy 1.4 syntax for the Oracle connection, e.g., oracle://username:password@hostname:port/?service_name=service.

This approach allows you to run Superset without an extra container for the Oracle client. Make sure to test the configuration to ensure everything works as expected.

To continue talking to Dosu, mention @dosu.

[jrlittlefoot64]

sorry for stupid question, where to put "python -m pip install oracledb"