In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Can I create a temp table in database and then reference it in a Connect In-DB query?

jdaouk
5 - Atom

I have been able to create temp tables and use them in joins to queries run in a Connect In-DB step, but ideally I want to reference the temp table within the query that is running in the Connect In-DB step. Is this possible?

Thanks!

1 REPLY 1
atcodedog05
22 - Nova
22 - Nova

Hi @jdaouk 

 

No its not possible join temp table with a table in Connect In-DB step.

 

Ideally, InDb tools works like a single set of sql query that data is not fetched until all the InDb tools are executed. Even though you are doing the join with after Connect In-DB step it will try to run it as a single step with join. 

 

With InDb tools you are just building the query you are not directly processing the actual data like normal tools.

 

Hope this helps : ) 

Labels
Top Solution Authors