We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Connect Knowledge Base

Definitive answers from Connect experts.

File Size alert on Alteryx Connect after removing assets

conorbroderick
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 databaseH2 (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 theHorizon

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