thoughtspot / cs_tools

Scale your ThoughtSpot adoption with tools created by the ThoughtSpot Solutions Consulting organization.
https://thoughtspot.github.io/cs_tools/
Other
9 stars 6 forks source link

Add more capabilities to archiver #22

Closed billdback-ts closed 1 year ago

billdback-ts commented 2 years ago

First Stop

Description

Archiver is a great tool, but there are some thing that would be nice to have.

  1. Add the ability to check lower in the dependency tree,e.g. worksheets and tables for stuff that isn't being used. This could be based on dependencies, so a table that has a worksheet that has content no one has viewed in a while.
  2. Add ability to check worksheets and tables for ones that aren't being searched.
  3. Isolate based on group(s) or users(0) to find their old content.
boonhapus commented 2 years ago

Looking through old issues.. some thoughts here.

  1. This is possible, but I'm unsure how useful it would be. What's the selection criteria here, if ANY activity has happened on a Worksheet's dependents? I think the best strategy for this option is to --dry-run dump to a Syncer (which didn't exist at the time this issue was opened) and then bash it up against TS_DEPENDENT_OBJECT in the Searchable tool. Also as part of v1.4.0 (#39), we're exploring a new tool which will bulk tag objects in your platform and interactive nicely with Syncers. This could achieve the more flexible requirements in content isolation for Archiver.

  2. This is not possible. ThoughtSpot does not expose which data source is being Searched against, so we cannot programmatically determine this.

  3. If this is an AND filter on top of other criteria in identify? I think that's relatively easy to implement.

boonhapus commented 1 year ago

This is resolved as part of V1.4.0 , check our documentation to learn more.

https://thoughtspot.github.io/cs_tools/tools/archiver/

img