Be sure to review our Idea Submission Guidelines for more information!
Submission GuidelinesWhen reading and writing large data frames to/from a python script in Alteryx it seems that there are limitations to the SQLite component of the tool. Given that this selection is recommended only when the user is having issues in the python tool why is the option selected by default? A colleague and I spent a couple of hours trying to work through an issue with importing a data frame larger than 1000x1000 and once we found this option (SQLite override) and unchecked it the data was written back to Alteryx without any problems.
Hint provided by the tool, "This changes the intermediate data format between Alteryx and Jupyter from yxdb to SQLite. Use only if running into issues. See help for more details."
SQLite override is default selection
Error message provided by the tool
After unchecking the option the workflow ran without any errors.
Recommendation: the python tool should default to SQLite override unchecked
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.