Monthly issue metrics report

[github-actions]

Issue Metrics

Metric	Average	Median	90th percentile
Time to first response	4 days, 7:17:04	4 days, 15:23:47	9 days, 18:03:57
Time to close	5 days, 22:26:18	6 days, 13:18:50	10 days, 11:20:02
Time to answer	None	None	None

Metric	Count
Number of items that remain open	71
Number of items closed	16
Total number of items created	87

Title	URL	Author	Time to first response	Time to close	Time to answer
🧹 Check AP user EFS lifecycle policy	#2551	bagg3rs	None	None	None
🐛 Delete table creates a new database, but copies no data across	https://github.com/ministryofjustice/data-platform/issues/2549	murdo-moj	0:46:59	None	None
🐛 Ensure new Create-A-Derived-Table Role has sufficent permissions to carry out all write operations	#2509	jhpyke	None	None	None
API Endpoint for creating new data product version without metadata/schema changes	ministryofjustice/data-catalogue#66	LavMatt	None	None	None
✨ Add copy flag to update table schema endpoint	ministryofjustice/data-catalogue#67	LavMatt	None	None	None
✨ New simple shiny app with write-permission to another app's web-bucket	#2504	ltd-pa	None	None	None
🚸 Process & Code for Separate Image Build Repos	#2502	julialawrence	None	None	None
🗒️ Create metadata before loading data	#2501	MatMoore	None	None	None
💣 "Delete means delete" when deleting a table	#2500	MatMoore	None	None	None
🎥 Status Page	#2490	Gary-H9	None	None	None
🎨 Install MOJ frontend in Data Platform control panel	#2488	michaeljcollinsuk	None	None	None
🐳 Create Dockerfile for Data Platform Control Panel	#2478	Gary-H9	None	7 days, 1:45:45	None
🧪 New Control Panel: Automated unit-testing Setup and env	#2479	Gary-H9	None	None	None
☸️ Helm Chart	#2482	Gary-H9	None	None	None
🔨 Deploy CI	#2481	Gary-H9	None	None	None
🧱 Build CI	#2480	Gary-H9	None	None	None
🐛 Flux fail to reconcile	#2476	Emterry	None	21:38:45	None
👷‍♂️ Build Infrastructure	#2484	Gary-H9	None	None	None
Investigate Data Hub	#2474	seanprivett	None	None	None
Investigate Data Zone	#2473	seanprivett	None	None	None
💂‍♂️ Setup Sentry	#2483	Gary-H9	21:16:59	None	None
🐛 Data failing validation is not removed from landing bucket	ministryofjustice/data-catalogue#68	LavMatt	None	None	None
Build API layer in Data Platform Control Panel to communicate with Labs API	#2458	michaeljcollinsuk	None	None	None
👤 User Request: Add iam:PassRole to Data Engineering SSO role	#2457	julialawrence	6 days, 23:56:25	9 days, 1:03:42	None
✨ Deploy DataHub into DPAT Development Cluster	#2454	julialawrence	None	None	None
PowerBI in AP: Implement requirements for PowerBI Gateway	#2452	julialawrence	None	None	None
📉 PowerBI in AP: Implement requirements for PowerBI Desktop	#2451	julialawrence	None	None	None
🐛 Helm failures in ingress renaming	#2450	Emterry	None	17:07:48	None
[:recycle:] Refactor Delete Table For Non Breaking Changes	ministryofjustice/data-catalogue#69	mitchdawson1982	None	None	None
Clear out of any previous iterations of data structures	ministryofjustice/data-catalogue#70	tom-webber	None	None	None
➕ Add redis container for local development	#2485	Gary-H9	None	None	None
🧠 Decide where Data Platform Control Panel is going to live	#2417	jacobwoffenden	None	None	None
📊 Block Control Panel Metrics	#2389	bagg3rs	None	None	None
📌 Version Pinning	#2477	Gary-H9	12 days, 23:47:44	None	None
📚 Remove Issues on data-platform-control-panel repository	#2486	Gary-H9	None	7 days, 19:16:38	None
🤝 Enable pull request approval mechanism on Modernisation Platform Environments repository	#2387	jacobwoffenden	None	4:39:38	None
[♻] Refactor Delete Data Product To Ignore Missing Components	ministryofjustice/data-catalogue#71	mitchdawson1982	None	None	None
🐛 curated tables created with extraction_timestamp rather then load_timestamp as partition	#2385	LavMatt	None	None	None
🐛 table json schema needs to use real type instead of float type	ministryofjustice/data-catalogue#72	LavMatt	None	None	None
🐛 Kyverno fails to properly exclude system namespaces in existing Airflow deployment	#2379	jhpyke	None	None	None
🔔 Airflow Alerting	#2377	Gary-H9	None	None	None
🔱 SPIKE: HTTP01 resolver on DPAT EKS	#2364	jacobwoffenden	None	5 days, 16:19:44	None
[🔥] Remove non versioning related changes from the VersionCreator class	ministryofjustice/data-catalogue#73	mitchdawson1982	None	None	None
⏰ Alert on secrets that are approaching expiration	#2352	jacobwoffenden	None	None	None
✨ Feat: Add support for launching Python 3.10 on the Analytical Platform Control Panel	#2348	jhpyke	None	None	None
🚨 Alerting on Eventbridge	#2331	Gary-H9	None	None	None
⚰️ Kill It with Fire (Alpha Edition)	#2330	julialawrence	1:30:07	None	None
🐛 Metadata updates assume that keys are the same between old and new version	#2325	MatMoore	None	9 days, 19:32:41	None
🐛 Delete table lambda doesn't work if there is no schema	#2324	MatMoore	None	15 days, 1:20:44	None
refactor daap-create-metadata response functions	ministryofjustice/data-catalogue#74	LavMatt	None	None	None
🔎 (Re)Enable CodeQL	#2270	jacobwoffenden	None	None	None
📝 Update our AP guidance to clarify app deployments and responsibilities	#2268	bagg3rs	None	None	None
📌Grab data products from DPR	#2267	seanprivett	1:00:26	None	None
🐛 Landing to raw is missing permissions to write to fail location	#2266	MatMoore	6 days, 7:55:23	None	None
🐛 Trivy scan fails when no critical vulnerabilities are detected	#2251	jacobwoffenden	1:00:27	2:34:28	None
🏷️ Integrate tagging with openmetadata	#2249	MatMoore	None	None	None
🔱 Investigate Excalidraw Teams	#2248	jacobwoffenden	None	None	None
🔥 Retire and replace legacy GitHub Teams	#2242	jacobwoffenden	None	None	None
📌 Spike: secure data requirements	ministryofjustice/data-catalogue#75	YvanMOJdigital	None	None	None
⚡ Add XRay to Observability Platform Role to allow Metrics collection	#2237	julialawrence	None	None	None
🔎 Implement RBAC in Grafana to allow Users to configure dashboards and alerts	#2236	julialawrence	7 days, 22:24:42	None	None
🔍 Define Alerts for our Modernisation Platform and route them	#2235	julialawrence	None	None	None
🔍 Setup DPAT Alerting Routes in Alpha Grafana	#2234	julialawrence	None	None	None
🧭 Joint Labs/DPAT effort: Authenticate Control Panel with Labs API using M2M flow	#2233	julialawrence	10 days, 4:58:46	None	None
💻 Implement Authn/authz via Auth0/LocalDB	#2232	julialawrence	None	None	None
Authentication setup for Control Panel v3 and Data Labs API	#2231	julialawrence	23:29:17	None	None
⚙️ UI for giving users access to the data product in AWS (user Management UI)	#2230	julialawrence	None	None	None
🥇 Microservice to retrieve IAM permission to allow AWS access from control panel	#2229	julialawrence	None	None	None
🧑‍🎨 Implement User Flow for Data Product Ingestion	#2228	julialawrence	None	None	None
🐛 Observability Platform Alpha Grafana unable to assume data-platform-production IAM role	#2213	jacobwoffenden	4 days, 19:10:44	4 days, 19:11:01	None
👁️ Get metadata endpoint	#2212	MatMoore	None	None	None
API endpoint - List all tables in a data product	ministryofjustice/data-catalogue#76	LavMatt	None	None	None
API endpoint - List all Data Products	ministryofjustice/data-catalogue#77	LavMatt	None	None	None
🗃️ Investigate whether we can use the OpenMetadata topology better	#2207	MatMoore	None	None	None
💻 Upgrade OpenMetadata to v1.2	#2206	julialawrence	None	0:01:43	None
Document steps to use the new shiny base image	#2204	michaeljcollinsuk	None	6 days, 0:51:55	None
🐛 Data product name missing from s3 logs of landing_to_raw	#2193	MatMoore	None	None	None
📌 Upgrade DPAT EKS cluster add-ons and platform components	#2180	jacobwoffenden	4 days, 15:23:47	7 days, 15:07:58	None
🔬 Review and scope down permissions for Open Metadata roles	#2179	jacobwoffenden	None	None	None
🚀 Update Open Metadata to 1.2	#2175	jacobwoffenden	None	11 days, 3:07:22	None
Pull metadata to the catalogue	ministryofjustice/data-catalogue#78	seanprivett	None	None	None
Use Mojap Metadata as the portable metadata object in the DaaP API	ministryofjustice/data-catalogue#79	tom-webber	None	None	None
🐛 Create schema: exception thrown generating error response	#2169	MatMoore	None	8 days, 23:20:52	None
🤖 Dependency Monitoring	#2167	Gary-H9	None	None	None
🐑 Create Data Platform template repository	#2166	jacobwoffenden	None	None	None
🐞 Add a way to lookup owner by email in OpenMetadata	#2165	MatMoore	None	None	None
🤖 Monitor Self-Hosted GitHub Action Software versioning	#2164	Gary-H9	None	None	None

This report was generated with the Issue Metrics Action
Search query used to find these items: repo:ministryofjustice/data-platform is:issue created:2023-11-01..2023-11-30 -reason:"not planned"