In-DB Connections VS Regular Connections

[abacon]

Hello all,

I am looking into the In-DB connections and if it is worth setting up. What are the pros and cons of getting them setup and is it worth doing when we have an Azure SQL Database?

Thank you,

bacon

[alexnajm · Accepted solution]

In theory it's supposed to reduce processing time by creating queries against the database rather than bringing all data to your machine and processing locally. Many In-DB workflows reduce the time of workflow runs :) I like this little FAQ about them: FAQ: How Do the In-Database tools Work?

I think it's worth trying and comparing against your standard Alteryx tools. Here's a bit more on them as well: In-Database Overview

[abacon]

@alexnajm Love it, thank you!

[alexnajm]

Small tip as well - if you have a current workflow already leveraging your Azure SQL connection, try building the exact same query with the In-DB tools. A lot of the tools can be "translated" one to one, and those that don't have that equivalency can be streamed out for standard processing (i.e. for spatial, reporting, etc.)!