SAS SQL Pass-Through Facility does not work as expected for Postgres database

Question

I am working with SCD Type 2 transformation in SAS Data integration Studio (4.905) and using Postgres (12) as database.

I am facing the following error when I try to execute a query via passthrough:

When using passthrough in Postgres, SCD Type 2 doesn't enclose the table name in quotes (which would keep the name uppercase, since postgres converts all unquoted data to lowercase) and so doesn't find it as you can see.

My questions are:

Is there a way to make SCD2 transformation declare the table’s name, used via passthrough, in quotes?

Is there a way to make the SCD2 transformation create intermediate tables ‘name in lower case so that the reference is not lost when doing passthrough?

Is there a global option in DI that allow us to modify/edit temporary table names?

Source and target tables are postgresql tables, with name and columns name in lowercase:

Please, if anyone has faced this problem before or knows what is missing, please, let I know.

You'll get a faster answer for DI questions on communities.sas.com — Reeza, Oct 06 '22 at 16:24
Not always. _(moreover, communities.sas.com too much organized as a chat box, too little as a knowledge base)_ — Dirk Horsten, Oct 07 '22 at 06:10

score 1 · Answer 1 · edited Oct 07 '22 at 16:27

1

To solve this issue, we have to select the following highlighted (source and target) table options.
It results in quotes around source/target table names:

Then, SCD2 transformation automatically put quotes in tables y columns names as you can see:

edited Oct 07 '22 at 16:27

Dirk Horsten

3,753
4
20
37

answered Oct 07 '22 at 10:02

Elton Rodrigues

21
5

SAS SQL Pass-Through Facility does not work as expected for Postgres database

1 Answers1