Deleting entire data tables

Post author
tmajarian

Hi-

I have multiple workspaces with 5+ data tables in each. I would like to delete each table in its entirety in each workspace -- to remove all data tables but keep the workspaces themselves. I am aware of how to do this through the GUI & API (although I am having issues with each) on an entity-by-entity basis. Is there a quicker/better way to bulk delete entire data tables?

 

Thanks!

-Tim

Comments

7 comments

  • Comment author
    Samantha (she/her)

    Hi tmajarian,

     

    Thanks for reaching out. If you want to delete the entire data table at once, you can select all rows in the table to delete, which will effectively delete the table itself. Unfortunately, there's no way to delete multiple tables at once.

    Can you elaborate on the issues you are having using the API?

     

    Best,

    Samantha

    0
  • Comment author
    tmajarian

    Hi Samantha-

    Sure. I'm actually having what seems to be the same issue with both the GUI and API. Using the method you described, I am getting a "failed to fetch" error:

    Using the API to delete the same entities gives me a time out error: ReadTimeout: HTTPSConnectionPool(host='api.firecloud.org', port=443): Read timed out. (read timeout=120).

     

    These tables were imported using Biodata Catalyst Gen3. 

     

    Thanks for looking into this for me.

    0
  • Comment author
    Samantha (she/her)

    Hi tmajarian,

     

    How many rows are in the table you are trying to delete? If possible, can you please share your workspace with GROUP_FireCloud-Support@firecloud.org and let us know the name of your workspace so we can take a closer look?

     

    Best,

    Samantha

    0
  • Comment author
    tmajarian

    There are only 9 rows in the table. The workspace is named "NIH_interop_BDCatalyst". I will share the workspace.

     

    Thanks!

     

    0
  • Comment author
    Samantha (she/her)

    Hi tmajarian,

    I cloned the workspace and was able to reproduce the error when attempting to delete the "study" table. I'll bring this to our engineers to look into and let you know what they say.

    Best,

    Samantha

    0
  • Comment author
    Samantha (she/her)

    Hi tmajarian,

    I brought this to our engineers and they think the deletion is timing out because Terra needs to make sure that there are no other entities in the workspace that contain references to any of the 9 entities, but there are a lot of references here so it's a bit slow. Deletion would probably still fail even if it didn't time out because you can't delete any entity that has references to it. If you try to just delete one of those rows instead of all 9, you should be able to get a more helpful error message.

    When I tried to delete one of the rows in the study table in the clone I created, the error message indicates that there are 21008 entities that reference it.

     

    Best,

    Samantha

    0
  • Comment author
    tmajarian

    Thanks! I am using the API to delete entities in batches which is working for me.

    -Tim

    0

Please sign in to leave a comment.