Automate process to easily ingest IAM MPI data and report on CSP counts (Part 2)

department-of-veterans-affairs / va.gov-team

Public resources for building on and in support of VA.gov. Visit complete Knowledge Hub:

https://depo-platform-documentation.scrollhelp.site/index.html

284 stars 206 forks source link

Automate process to easily ingest IAM MPI data and report on CSP counts (Part 2) #56509

Open elizabethmkoch opened 1 year ago

elizabethmkoch commented 1 year ago

Issue Description

The login.gov adoption team, stakeholders, and VA leadership need to review data and analyze CSP counts and CSP method changes to track login.gov adoption.

User Story

As a Product Owner I want to know the total user counts by CSP accessing the va.gov ecosystem as we progress through the migration So that we can track adoption.

Configure Domo and Domo Workbench to load new datasets

[ ] install Domo Workbench on shared server
[ ] configure Domo to detect newly exported datasets and initiate load
[ ] load as partitioned dataset
[ ] configure Domo ETL to automatically run with updated datasets

Update dashboard

[ ] confirm dashboard visualizations include view of changes over time

Acceptance Criteria

[ ] Process automated on regular weekly cadence

sdickson-gt commented 9 months ago

have submitted a request for shared desktop: RITM11261207

sdickson-gt commented 8 months ago

There's been no movement on above ticket. Will need to escalate.

sdickson-gt commented 7 months ago

The ticket doesn't yet have anyone assigned that I can reach out to directly or escalate to their manager.

SophiaPhilipMO commented 7 months ago

@Samara-Strauss and @blacktm we are experiencing a blocker with getting this request addressed. It was submitted on SNOW, see link to ticket here though not sure if you are able to access. The ticket being blocked due to no response is also reflected in screenshot in prior message in thread. We need a point of contact for VA Infrastructure for hosting an application for ETL (Extract, Transform, Load) automation to monitor CSP counts.

Do either of you know a POC or possible channel to follow up on this ticket?

Samara-Strauss commented 7 months ago

@SophiaPhilipMO I had a chance to regroup on this with @blacktm, and we think it's best to close this ticket for now. Tom and I need to figure out what data we need before we can direct this or any related work.