community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Multiple Queries In-Database

Highlighted
Magnetar
Magnetar

Two thoughts:

 

You can write something like:

SELECT a.name FROM

(SELECT name FROM agentinformation) a 

In a regular Input Data tool and Alteryx will handle it fine.  I have sometimes found that Alteryx has a hard time with these types of queries in the In-Database tools (since from a technical perspective, the In-Database tools create very similar subqueries, so they don't always nest appropriately).

 

 

 

With regards to write permissions needed for temp tables - I'm not an expert on SQL Server or any other database technology, but my understanding is that typically the ability to create temp tables and the ability to write to a permanent table are two separated permissions, so it is possible to have access to use In-Database without having permission to create a New Table.

Labels