I found a solution.

To reference any tables in Stored Procedure / ETL , you need to reference how it is named in Postgres.

For example, if I have an assay called "test", in Postgres, it is stored in "assayresult" with the table name of "c123456_test".

So to reference it in Postgres, you would use: assayresult.c123456_test .

Thanks!