Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Database Stream In - Schema Selection

cyoung3
6 - Meteoroid

I am trying to stream a text output into the database as a temporary table, but it is automatically attempting to create the temporary table in the public schema (as opposed to the schema I have access to create temp tables in). Is there any way to specify the schema to create the temp table in? 

 

p.s. all of my in-db connections are working in all other areas and I am able to specify the schema in my queries. 

 

cyoung3_0-1631125740249.png

 

1 REPLY 1
patrick_mcauliffe
14 - Magnetar
14 - Magnetar

@cyoung3  you should be able to specify the default schema in your database connection (assuming ODBC).  That would change where the temp table is written.

Labels