Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

Add cache to SQLite in Input Tool

When using an SQLite database file as an input, please provide the option to Cache Data as is available when opening an ODBC database.  Currently, every time the input tool is selected, it takes an inordinate amount of time for Alteryx to become responsive; especially if the query is complex.  SQLite is not a multi user database and is locked when accessed so there is no need to continuously poll it for up-to-date values.  Pulling data when run or if F5/Refresh is pressed would be sufficient.

 

The issue may be more primitive than what is solved by having a Cache Data option.  I am more concerned that the embedded query seems to be "checked" or "ran" every time the tool is selected.  I think this issue was resolved with other file formats but SQLite was overlooked.

3 Comments
Status changed to: Inactive
 

The status of this idea has been changed to 'Inactive'. This status indicates that:

 

1. The idea has not had activity in the form of likes or comments in over a year.

2. The idea has not reached ten likes.

3. The idea is still in the 'New Idea' status. 

 

However, this doesn't mean your idea won't be implemented! The Community can still like and comment on this idea. With enough renewed interest, this idea can be brought back into the 'New Idea' status. 

 

Thank you for contributing to the Alteryx Community and the Alteryx Product Idea Boards!

Alteryx
Alteryx
Status changed to: Implemented

Thank you for this suggestion! The 'Cache Data' check box was added to the SQLite database format, and is available in the 2019.4 release: http://downloads.alteryx.com/