iframe-proxy | Sunbelt Computer Software

This repository was archived by the owner on Mar 6, 2026. It is now read-only.

38 lines (32 loc) · 1.26 KB

# Copyright 2019 Google LLC
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#     https://www.apache.org/licenses/LICENSE-2.0
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
def client_query_w_struct_params():
    # [START bigquery_query_params_structs]
    from google.cloud import bigquery
    # Construct a BigQuery client object.
    client = bigquery.Client()
    query = "SELECT @struct_value AS s;"
    job_config = bigquery.QueryJobConfig(
        query_parameters=[
            bigquery.StructQueryParameter(
                "struct_value",
                bigquery.ScalarQueryParameter("x", "INT64", 1),
                bigquery.ScalarQueryParameter("y", "STRING", "foo"),
    query_job = client.query(query, job_config=job_config)  # Make an API request.
    for row in query_job:
        print(row.s)
    # [END bigquery_query_params_structs]

Sunbelt Computer Software

PL/B Language Development and Support

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Sunbelt Computer Software

PL/B Language Development and Support

Uh oh!

FilesExpand file tree

client_query_w_struct_params.py

Latest commit

History

client_query_w_struct_params.py

File metadata and controls