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.
Hi, sometimes I need to work outside the office on trains or other rural areas where the internet connection is slow (or no internet at all). Working in Alteryx Designer is then very frustrating and time-consuming. It seems like every time I enter a tool, add a new tool or do any operations at all in the workflow; Alteryx is checking the metadata of all the connections and won't let me do anything before all database connections are checked.
I'm using ODBC-connections to SQL-server both with Input Data-tool and Connect In-DB-tool. I have Alteryx Designer 2019.1.
Is it possible to turn off updates of metadata to my database-connections like I can turn off automatic calculations in Excel?
May I alternatively work in Offline-modus where Alteryx is using the last know metadata information?
PS: That is goes slower to Run a workflow with bad internet connection is expected, and not what frustrates me.
I have run into this issue before as well and usually solve it 1 of 3 ways depending on whats best from you.
1. If possible for your business problem, consider loading only 100 or so rows instead of full population. This will enable you in poor connections to download small amounts of data that even on poor networks shouldn't take too long.
2. Download the data trying to be pulled from DB into a .yxdb or other local file you can use during bad connections, then swap out when in better network
3. Cache tool should allow you to run your workflow before you leave office or wherever you are heading and store it in your workflow so it doesn't have to go back out to server every time you press run.
Hope 1 of these solutions helps you out, let me know if you have any questions.