[Task]: YAML - E2E example pipelines for common use cases #35030

What needs to happen?

Adding E2E example pipelines based on common. use cases.

• Phase 1 - Reorganize example location and add blueprints section - https://github.com/apache/beam/blob/master/sdks/python/apache_beam/yaml/examples/README.md
  Update yaml example readme and organization #35038
  add doc string to examples test file #35040
  add input data file for example tests #35054
• Phase 2 - High probable usage with yaml components ready
  [yaml]: Phase2 High Usage Yaml examples #35279
• Phase 3 - Moderate probable usage with yaml components ready
  [yaml]: Phases 3-4 Moderate-High Usage Yaml examples  #35423
• Phase 4 - Low probable usage with yaml components ready
  [yaml]: Phases 3-4 Moderate-High Usage Yaml examples  #35423
  - [ ] Phase 5 - Update yaml generated docs after Phase 4 is complete - Will be covered by release process.
• Phase 6 - Moderate probable usage, but waiting on yaml components being ready
  gcs_avro_to_cloud_bigtable - Add gcs_avro_to_bigtable yaml blueprint example and e2e test #40484
  mongodb_to_bigquery - Add mongodb_to_bigquery yaml blueprint example and e2e test #40485
  bigquery_to_bigtable - Add bigquery_to_bigtable yaml blueprint example and e2e test #40472
  cloud_pubsub_to_splunk - Missing Splunk support
  - [ ] Phase 7 - Update yaml generated docs after Phase 6 is complete - Will be covered by release process.

Issue Priority

Priority: 2 (default / most normal work should be filed as P2)

Issue Components

• Component: Python SDK
• Component: Java SDK
• Component: Go SDK
• Component: Typescript SDK
• Component: IO connector
• Component: Beam YAML
• Component: Beam examples
• Component: Beam playground
• Component: Beam katas
• Component: Website
• Component: Infrastructure
• Component: Spark Runner
• Component: Flink Runner
• Component: Samza Runner
• Component: Twister2 Runner
• Component: Hazelcast Jet Runner
• Component: Google Cloud Dataflow Runner