Create a pinboard and worksheet based on database, tables and storage consumption

Hello , i want to create a pinboard and worksheet of thoughtspot (carrying information about database,its tables and memory size it consumed)

4replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • If you have access to the admin tab, click system health and then Data and it will give you all of that information within the table information answer 

    Like
  • Yes i can see them, but i cannot filter and view data. i want to now create custom pin boards and visualization over that information. 

    Is there any possibility as a admin to get real time information (Database,Table ,Size usage)

    so i can go ahead create a worksheet and pinboard on it?

    Like
  • I am talking about customized views and reports on usage

    Like
  • Hi Ashlin,

     

    You can use TS: Internal Table Wise Capacity WS to your source to get all required information . Steps would be:

    1. Choose TS: Internal Table Wise Capacity WS as your data source.

    2. Query : ‘yesterday’  ’Table Name’ ‘total csv size with replication (gb)‘ ‘total Row Count’ ‘total Shards’ 

     

    Here, Table Name shows "Database.SchemaName.TableName". You can use formulas to segregate this too. Also, information on this view is refreshed daily, so don't forget to put a "yesterday" filter in search bar to get the latest. Hope this helps.

    Like 2
Like Follow
  • Status Answered
  • 1 mth agoLast active
  • 4Replies
  • 32Views
  • 3 Following