Develop a custom Python script utilizing the BigQuery API to execute the query. This script would need to be containerized and deployed as the first step in your Kubeflow pipeline, requiring additional setup for authentication and data handling.

Manually execute the query via the BigQuery console, then export the results to a new BigQuery table. This table would then be referenced in the subsequent steps of your pipeline, introducing manual steps and potential delays.

Create a custom component using the Kubeflow Pipelines domain-specific language (DSL) that leverages the Python BigQuery client library. This approach offers flexibility but requires significant development effort to handle query execution and result processing.

Utilize the pre-built BigQuery Query Component available in the Kubeflow Pipelines GitHub repository. By referencing this component's URL in your pipeline, you can seamlessly execute queries against BigQuery without the need for custom development.

Combine the use of the pre-built BigQuery Query Component for query execution with a custom component for data transformation, ensuring optimal performance and flexibility. This hybrid approach leverages existing solutions while addressing specific project needs.