79436512

Date: 2025-02-13 14:33:58
Score: 1
Natty:
Report link

Well, I found another way to solve it

Since I there is specific user for this connection, I found that I can set the schema "at user level" with:

ALTER USER <my user> SET SEARCH_PATH TO <my schema>

With this, connections made through my linkedservice with that specific user, will be set to the desired schema transparently

Reasons:
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Smoke Less