We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

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

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

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?


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 : )