Be sure to review our Idea Submission Guidelines for more information!
Submission GuidelinesWhen moving external data into the database, the underlying SQL looks like:
CREATE GLOBAL TEMPORARY TABLE "AYX16020836880b41e08246b59ee8c"
...
My client would like to add a prefix to the table as:
CREATE GLOBAL TEMPORARY TABLE MMMM999_DM_USER."AYX16020836880b41e08246b59ee8c"
where MMMM999_DM_USER is supplied in the configuration.
A service account automatically sets the current session to something like MMMM999 (alter session set curent schema=MMMM999;)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.