could not open relation with OID xxxxxx

Help
1

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.

2 Likes
2

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