This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm reaching out in hopes of learning how other deal with foreign key lookups in Alteryx.
I have workflows that are destined for destined for a Microsoft Azure SQL Database table. However, before I can execute the insert, I often need to look up a foreign key value from another table in my Azure SQL Database. Currently, I'm using two different methods to perform this task.
1. Dynamic Input tool with a dynamic where clause. - This approach is straight -forward, but I find it extremely slow and is just not viable for a large dataset.
2. My second approach is to stream data out to a temporary in-database table, use the In-database connect tool to query the table containing the foreign key. Then I perform an in-database join to get my foreign key and finally I stream the data out of the in-database tool back to the original workflow.
The second approach is faster than the first, but far from elegant.
If anyone has an alternative approach that works well I would be very interested in hearing from you.