# could not open relation with OID xxxxxx

**URL:** <https://discourse.getdbt.com/t/could-not-open-relation-with-oid-xxxxxx/7903>\
**Category:** Help\
**Tags:** redshift\
**Created:** [April 18, 2023, 6:38pm UTC](https://discourse.getdbt.com/t/could-not-open-relation-with-oid-xxxxxx/7903 "2023-04-18T18:38:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mathi.raj](https://avatars.discourse-cdn.com/v4/letter/m/eada6e/32.png) [@mathi.raj](https://discourse.getdbt.com/u/mathi.raj)\
**Post date:** [April 18, 2023, 6:38pm UTC](https://discourse.getdbt.com/t/could-not-open-relation-with-oid-xxxxxx/7903/1 "2023-04-18T18:38:58Z")

</div>

Hi,  
While loading the data into Redshift, getting an error “could not open relation with OID xxxxxx”.  
The script is selecting the data from the table built by dbt. There is an extra column that has the LEAD() function to update the date. No transformations in all the other columns.  
Any help is much appreciated.

---

<div class="post-metadata">

**Author:** ![drapail](https://avatars.discourse-cdn.com/v4/letter/d/b38774/32.png) [@drapail](https://discourse.getdbt.com/u/drapail)\
**Post date:** [March 29, 2024, 7:52pm UTC](https://discourse.getdbt.com/t/could-not-open-relation-with-oid-xxxxxx/7903/2 "2024-03-29T19:52:15Z")

</div>

Did you find a solution for this problem? I have the same issue. Using dbt 1.7.3 and Redshift connector 1.7.0