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

Alteryx
Alteryx
Created

File Size alert on Alteryx Connect after removing assets

 

 
 
conorbroderick_2-1580231891574.png

 

 

  • 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