In-Database Temporary Table Prefix

[MarqueeCrew]

When 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;)

[Community_Admin]

The status of this idea has been changed to 'Inactive'. This status indicates that:

1. The idea has not had activity in the form of likes or comments in over a year.

2. The idea has not reached ten likes.

3. The idea is still in the 'New Idea' status. 

However, this doesn't mean your idea won't be implemented! The Community can still like and comment on this idea. With enough renewed interest, this idea can be brought back into the 'New Idea' status. 

Thank you for contributing to the Alteryx Community and the Alteryx Product Idea Boards!

[i_love_databases]

Hello @MarqueeCrew,

I think this idea may interest you, it's basically the same : https://community.alteryx.com/t5/Alteryx-Designer-Ideas/In-DB-Choose-the-base-or-schema-of-the-Temp-...

Best regards,

Simon