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

[jdaouk]

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!

[atcodedog05]

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