Hi all,
I've found a niche within my company of making Alteryx macros which connect to a wide variety of cloud data sources. Most of these macros rely on building ODBC connection strings and utilizing ODBC drivers installed on the user's machine, while a few others make heavy use of the Python tool. Recently, I've been give the directive to revisit these macros and make performance improvements in any way that I can. I imagine most of these performance improvements will come from making change to the structure of my connection strings to utilize the full capabilities of the various drivers. But before I went down that road, I wanted to know if there were any general tips and tricks I can use to improve the performance of my macros before I move to addressing driver-specific issues.
