Expand CompanyAnalytics table to capture the date of activation and possible the status for each dashboard🟢
https://app.claap.io/caddetails/c-eDsAAtvmPP-ttxkTBCAWg1i
Current Limitations: The existing Company Analytics Table lacks the capability to track when analytics resources are activated for companies. This limitation hinders the ability to monitor the activation status of analytics resources.
Proposed Enhancements: The proposal includes expanding the Company Analytics Table or creating a related table to track the activation of analytics resources. This would involve recording the company ID, resource ID, timestamp of activation, and a boolean status indicating whether the resource is active or inactive.
Implementation Considerations: The implementation could involve either modifying the existing table to include timestamps and status flags or creating a new Company Analytics Status Table. The urgency of this enhancement is emphasized, as it is necessary for assigning go-live dates to analytics dashboards.
Let me know if you have questions!
Log in to comment and vote
Comments1
El
Oct 19
This can be archived as the snowflake MCP should be used for this purpose.