Abhishek Singh

Results 92 comments of Abhishek Singh

@JeremyDel It would good to check database name if it is lowercase or uppercase. I am suspecting there is some mismatch in the metadata. ```sql select SYS_CONTEXT('userenv', 'DB_NAME') from dual;...

Also, is this on-prem or Autonomous database ?

Could you try after enabling quoting only for `database` ? ```yaml quoting: database: true ```

We are investigating this. We use python-oracledb as the underlying database driver. So, any external authentication method needs to be supported by the driver

@aadishsanghvi Could you let me know how do you connect to Oracle Database using SQLPlus and Kerberos Authentication ? I am interested in understanding the SQL net configuration used. Also,...

@aadishsanghvi I know of cx_Oracle and python-oracledb. Could you share the code using cx_Oracle to connect using Kerberos ?

Hi @aadishsanghvi We are working on it. The plan is to make this a part of `dbt-oracle==1.9.0` which we plan to release in January 2025.

dbt-oracle uses [python-oracledb](https://oracle.github.io/python-oracledb/) for Connecting to Database. We will check if the Python driver supports LDAP authentication

@VenkatArra Could you give some details ? - is the database On-prem or Autonomous Database in Cloud ? - is the LDAP server in OCI ? - Have you tried...