Difference between InputData vs In-DB

[michellekim]

Hi all

I was wondering when do we use the Input Data > Quick Connect > SQL server and when do we use the In-Database ..

What are the differences? and what's the benefit of using the In-Database as opposed to the quick connect?

Have a good day!

[cmcclellan · Accepted solution]

Input Data tool - Alteryx reads all the records in to memory and then processes

inDB tools - Alteryx creates temp tables inside the database.

If you have the choice use inDB because they are much faster when you're talking about large quantities of data.  The tradeoff is that you can't "see" the data (an inDB Browse is completely different to a normal Browse) and not everything can be done inDB.

[michellekim]

Great thanks for the explanation 🙂