fix(ingest/bigquery): optimise queries v2 session processing #24498

Job	Run time
setup	27s
Build and Push DataHub GMS Docker Image	0s
Build and Push DataHub MAE Consumer Docker Image	0s
Build and Push DataHub MCE Consumer Docker Image	0s
Build and Push DataHub Ingestion (Base) Docker Image	12s
Build and Push DataHub Upgrade Docker Image	0s
Build and Push DataHub Frontend Docker Image	0s
Build and Push DataHub Kafka Setup Docker Image	0s
smoke_test_matrix	1s
Build and Push DataHub MySQL Setup Docker Image	0s
Build and Push DataHub Elasticsearch Setup Docker Image	0s
[Monitoring] Scan GMS images for vulnerabilities	0s
[Monitoring] Scan DataHub Upgrade images for vulnerabilities	0s
[Monitoring] Scan Frontend images for vulnerabilities	0s
[Monitoring] Scan MCE consumer images for vulnerabilities	0s
[Monitoring] Scan MAE consumer images for vulnerabilities	0s
Build and Push DataHub Ingestion (Base-Full) Docker Image	8s
Build and Push DataHub Ingestion (Base-Slim) Docker Image	8s
Build and Push DataHub Ingestion (Full) Docker Images	8m 10s
Build and Push DataHub Ingestion Docker Images	3m 27s
[Monitoring] Scan Datahub Ingestion Slim images for vulnerabilities	3m 11s
Run Smoke Tests (no_cypress_suite0)	32m 55s
Run Smoke Tests (no_cypress_suite1)	24m 39s
[Monitoring] Scan Datahub Ingestion images for vulnerabilities	4m 24s
Deploy to Datahub HEAD	0s
	1h 17m 42s

Provide feedback