Read latest ingested SBOM pipeline id from Redis

Mehmet Emin INACrequested to merge
store_pipeline_id_on_redis_for_sbom into master

What does this MR do and why?

Finding the latest ingested SBOM pipeline via running SQL query is expensive and timing out, therefore, we've decided to utilize Redis to store and retrieve this information.

Related to #422920 (closed).

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Mehmet Emin INAC

Merge request reports