# Unable to connect OCI SQL Endpoint

**URL:** <https://discourse.getdbt.com/t/unable-to-connect-oci-sql-endpoint/11894>\
**Category:** Help\
**Created:** [February 5, 2024, 11:05am UTC](https://discourse.getdbt.com/t/unable-to-connect-oci-sql-endpoint/11894 "2024-02-05T11:05:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mahipal](https://avatars.discourse-cdn.com/v4/letter/m/958977/32.png) [@mahipal](https://discourse.getdbt.com/u/mahipal)\
**Post date:** [February 5, 2024, 11:05am UTC](https://discourse.getdbt.com/t/unable-to-connect-oci-sql-endpoint/11894/1 "2024-02-05T11:05:18Z")

</div>

## The problem I’m having

Im trying to connect to an SQLEnpoint using dbt-spark’s ODBC connection, but couldn’t succeed

## The context of why I’m trying to do this

## What I’ve already tried

Tried with different configs, but I get

```auto

10:52:18 1 check failed:
10:52:18 dbt was unable to connect to the specified database.
The database returned the following error:

  >Runtime Error
  Database Error
    failed to connect

```

## Some example code or error messages

```auto
dbtdf11:
  outputs:
    dev:
      driver: /Library/simba/ocispark/lib/universal/libsparkodbc_sbu.dylib
      method: odbc
      host: <host>
      threads: 1
      schema: default
      type: spark
      user: admin
      password: admin
  target: dev

```

Error doesn’t have full info, any help appreciated.

---

<div class="post-metadata">

**Author:** ![david.allan](https://avatars.discourse-cdn.com/v4/letter/d/ee7513/32.png) [@david.allan](https://discourse.getdbt.com/u/david.allan)\
**Post date:** [February 20, 2024, 7:34pm UTC](https://discourse.getdbt.com/t/unable-to-connect-oci-sql-endpoint/11894/2 "2024-02-20T19:34:14Z")

</div>

Hi, I posted posted this which has more of a hack to get it working but you can explore. I’ve been working on creating a new adapter so that both SQL and python models work. But this might give you a quick experience. [Leveraging dbt with OCI Dataflow: Supercharging Your Data Analytics Workflow on OCI | by David Allan | Jan, 2024 | Medium](https://dave-allan-us.medium.com/leveraging-dbt-with-oci-dataflow-supercharging-your-data-analytics-workflow-on-oci-ef4f622ca5e0?source=friends_link&sk=35a1c88c97f856a241486ad40de50392)  
Cheers  
David