Oracle Support

[nevintan]

View in #gx-community-support on Slack

@karthick: Hello Team, I recently started working on GX library. Initially we have implemented GX with source as BigQuery. There we used add_sql() method for datasource and add_query_asset() for data asset and it was working fine. Now we are changing the source from BigQuery to Oracle database. In the add_sql() I’m passing connection string as “oracle+oracledb:…” and in data asset I’m passing the valid query. But it is failing inside GX saying missing right parenthesis. I made many trials, but of no use. Can u please suggest a wayforward to deal with Oracle database

[nevintan]

Unfortunately Oracle is not officially supported by GX Core. I would suggest taking a look at installing any dependancies as described in the SQLAlchemy Documentation and going from there. If you are able to connect, please let the community know!