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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
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