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.