Skip to content

add support for parameterized-queries in bqfrag #53

@ingarabr

Description

@ingarabr

https://cloud.google.com/bigquery/docs/parameterized-queries

 String query =
  "SELECT word, word_count\n"
    + "FROM `bigquery-public-data.samples.shakespeare`\n"
    + "WHERE corpus = @corpus\n"
    + "AND word_count >= @min_word_count\n"
    + "ORDER BY word_count DESC";

QueryJobConfiguration queryConfig =
  QueryJobConfiguration.newBuilder(query)
     .addNamedParameter("corpus", QueryParameterValue.string(corpus))
     .addNamedParameter("min_word_count", QueryParameterValue.int64(minWordCount))
     .build();

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions