Alteryx Connect Knowledge Base

Definitive answers from Connect experts.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

File Size alert on Alteryx Connect after removing assets


File Size alert on Alteryx Connect after removing assets





  • The size of the database files depends on the activity made in the system. If you are removing assets from Connect using soft-delete (assets marked as deleted ) the database size is still increasing.
  • Synchronizing and adding more assets into Connect will also increase the size of the database.
  • Alteryx Connect uses database H2 (version .197) which does not support auto shrinking functionality so removing items from the trash will not shrink the database by itself. 




What can I do to reduce the size of my database ?


  • Perform a Defrag 
  • Perform a Compact 
  • Set Soft-Delete to False


On the Horizon


  • In 2020.1 Alteryx Connect will be upgrading to H2 version .200 which will include auto shrinking functionality