Allow user to collect a new statistics snapshot from BQ

Description

PRDE - Bug default text according to the team DoR (Definition of Ready)

01 - PERSON OF CONTACT (PERSON THAT CAN ANSWER QUESTIONS ABOUT THE PROBLEM):

@Douglas Coimbra Lopes

02 - PROBLEM (WHAT'S THE ISSUE?):

  • Once we access the Home Page on CCarol, the entities responsible to be loaded by the BQ endpoints are taking too much time to load.
  • Entities:
  • Total Golden Records
  • Staging tables with more Records and Events
  • Data models with more Records and Events
  • the environment in production: https://qas.carol.ai/qabq/carol-ui/home

03 - STEPS TO REPRODUCE (STEP (1...N), VIDEO, SCREENSHOTS, LOGS FOLDER, HEARTBEAT, ETC. – IF IS NOT POSSIBLE TO REPRODUCE EXPLAIN THE REASON):

  • Access Home Page
  • Check how much time it takes for the entities to be loaded on the home page

04 - LINKS (ADD A LINK TO THE BUG OR TO THE TENANT):
05 - EXPECTED BEHAVIOR (LIST THE EXPECTED BEHAVIORS TO CONSIDER THIS BUG AS DONE):

  • Flow when it takes longer to load the data.
  • Flow explaining the data we are showing is the cache (updated XX minutes ago).
  • Flow when the data is fresh (current flow).

06 - ASSETS

  • Add tag to update BQ stats on the homepage cards with BQ
  • This buttons would update every other BQ stats of the page
  • On the tooltip show last update date/time
  • On data model and staging apply “reload” icon to the corresponding table column, and show last updated on tooltip

https://www.figma.com/file/FiL1iRG6RPjuNCgVzgGqvaZ3/%F0%9F%9F%A3-Carol-3.0?type=design&node-id=34104-60346&mode=design&t=BA7BilC1FVMYakJS-4

Data models: https://www.figma.com/file/FiL1iRG6RPjuNCgVzgGqvaZ3/%F0%9F%9F%A3-Carol-3.0?type=design&node-id=27059-147000&mode=design&t=BA7BilC1FVMYakJS-4

Staging tables: https://www.figma.com/file/FiL1iRG6RPjuNCgVzgGqvaZ3/%F0%9F%9F%A3-Carol-3.0?type=design&node-id=34062-110003&mode=design&t=BA7BilC1FVMYakJS-4